| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Special Date Function
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Special Date Function
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... "Christopher D" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste special function | Excel Discussion (Misc queries) | |||
| Copy/Paste Special (Date Format) | Excel Discussion (Misc queries) | |||
| Paste Special Function | Excel Discussion (Misc queries) | |||
| Special function | Excel Worksheet Functions | |||
| special function help needed | Excel Worksheet Functions | |||
Hybrid Mode
