View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default programming date functions

Try this:
If your first date is in A1, then
A2: =A1+30
Copy cell A2 down as far as you need.

Does that help?

***********
Regards,
Ron


"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?