View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default programming date functions

One way:

A2: =A1+30
A3: =A2 + 60

Format as dates.

In article ,
"Gail" wrote:

I need my cells to auto date 30 days from the date in the first cell 60 days
from the date in the 2nd and so on. How do I do this?