Thread: Date formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bill Ridgeway Bill Ridgeway is offline
external usenet poster
 
Posts: 268
Default Date formula

"Will Emms" wrote in message
...
Hi there,
That's great. Now do you have any idea how I can hide the values the
formula
is generating when the original date cell is blank or zero?
Cheers,
Will

"Will Emms" wrote:

Hi there,
I want to set up a formula so that when I enter a date in one cell the
cell
with the formula gives me a date 4 days in advance.
Any ideas?
Many thanks,
Will


=IF(C4="","",C4+1)

Regards.

Bill Ridgeway
Computer Solutions