View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default entering date functions

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?