Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would llike to enter a date in one cell and have the next cell calcuate
what the date would have been 30 days before that date, example cell A! would have the date of 10/31/04 cell B1 would calculate 30 days before, so it would read 10/01/04 |
#2
![]() |
|||
|
|||
![]()
cell d5 entry is 12/17/04
in D6 type =D5-30 you get 11/17/04 help me wrote in message ... I would llike to enter a date in one cell and have the next cell calcuate what the date would have been 30 days before that date, example cell A! would have the date of 10/31/04 cell B1 would calculate 30 days before, so it would read 10/01/04 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date formula | Excel Discussion (Misc queries) | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) |