ExcelBanter - edate function

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

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

- - edate function (https://www.excelbanter.com/excel-worksheet-functions/81513-edate-function.html)

I Cruz

edate function

Is there a way to get the edate function in excel to calculate for 75 days?
As it's written now it calculates for 30, 60, 90, 120, etc....

Thank you

Niek Otten

edate function

=A1-75
Format as General, not as Date, which Excel would do automatically

--
Kind regards,

Niek Otten

"I Cruz" wrote in message ...
Is there a way to get the edate function in excel to calculate for 75 days?
As it's written now it calculates for 30, 60, 90, 120, etc....

Thank you

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