Special Date Function

C

Christopher D

I am trying to include a Date cell on my spreadsheet that is automatically
populated by the previous Date cell + 30 days.

Is there any sort of formula in Excel 2002 (XP) that can do that?
 
S

Sheeloo

Enter the first date in A1

Enter this in A2
=A1+30
and copy down

Format Col A as Date...
I don't have access to Excel 2002 but I believe this works in all versions...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula to incrementally increase a value by 1 every 365 day 2
Adding days to a date - changed in Excel 2010 8
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel Excel due and overdue date colours 2
Workday Formula to include date 0
Inserting current date 8
Returning date instead of 'not null' 4
Date Range 1

Top