Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hi All!
I need a formula to count back 300 days from a given date. Does anybody have a suggestion as to how to accomplish this? |
#2
![]() |
|||
|
|||
![]()
The below formula assumes that the date you want to count back from is in
cell A1. =A1 - 300 Ensure that whatever cell you put this formula into is formatted with a date format. If 5/15/2005 is in cell A1 the above formula should equal 7/19/2004. Hope this helps. Thanks, Bill Horton "Kira" wrote: Hi All! I need a formula to count back 300 days from a given date. Does anybody have a suggestion as to how to accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculating with dates | Excel Worksheet Functions | |||
Calculating dates | Excel Discussion (Misc queries) | |||
Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
Calculating Due Dates Based on Payments | Excel Worksheet Functions | |||
Using imported Query & Calculating Dates | Excel Worksheet Functions |