View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Megan Megan is offline
external usenet poster
 
Posts: 56
Default calculating dates automatically

Thanks you all! I nkow it was an easy answer but I am just getting started :)
appreciate your time. mg

"Bob I" wrote:

Format column "B" as Date and plug in =A1+5 and copy down to the rest of
the cells

Megan wrote:

I would like to make a template that allows me to enter a date in to one
column and have the second column automatically calculate the date that
occurs 5 days later. If anyone can help me with setting this up I would
REALLY appreciate it.

Thanks for your time,
Megan