Thread: Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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