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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks