View Single Post
  #4   Report Post  
Old November 22nd 05, 06:20 PM posted to microsoft.public.excel.worksheet.functions
Gail
 
Posts: n/a
Default entering date functions

Thank you that was easy enough

"Roger Govier" wrote:

Hi Gail

With your start Date in A1, format cells B1 and C1 with the same Date format.
In B1 =A1+30
In C1 =A1+60

Regards

Roger Govier


Gail wrote:
I would like to set up my worksheet so that I can enter a date in one cell
and make the next cell automatically be dated for 30 days later and the next
for 60 and so on. Is there a function I can program to set this up? If so
what is it?