Thread: Date formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Date formula

=c1 +4
will work after you format the cell

"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