ExcelBanter - Dates

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

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

- - Dates (https://www.excelbanter.com/excel-worksheet-functions/56281-dates.html)

Deion007

Dates

I would like to subtract 10 days from a date automatically on the first of
the month. How can I do that? Please speak slow, I'm new

Gary''s Student

Dates

If cell A1 contains =TODAY() then in A2 enter:

=IF(DAY(A1)=1,A1-10,"") and format as date.
--
Gary's Student

"Deion007" wrote:

I would like to subtract 10 days from a date automatically on the first of
the month. How can I do that? Please speak slow, I'm new

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