ExcelBanter - calculating dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - calculating dates (https://www.excelbanter.com/excel-worksheet-functions/38603-calculating-dates.html)

Kira

calculating dates

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?

William Horton

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?

All times are GMT +1. The time now is 07:02 PM.