Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workday Formula to include date 0
Excel Vba to change displayed year automatically. 14
Multi NetWorkDays Calculation 3
Calculate Start Date 4
Excel Message box with days of month & date. 1
Update cell value based on name and specific date 1
Remove weekends 2
Excel Monthly Spread sheet. 12

Back
Top