how do I subtract time from a date to get an earlier date?

  • Thread starter Thread starter Sunny_Dreams
  • Start date Start date
S

Sunny_Dreams

Hi - I am trying to set a 'reminder' date by subtracting 4 months from a
given date, such as 3/1/09 so that I get 11/1/08.
 
Here you go. You could replace B1 with your value as part of the formula if
you didn't want to use another cell.

A1: 12/1/2007
B1: 3 (Months to subtract)
A3: =DATE(YEAR(A1),MONTH(A1)-B1,DAY(A1))
 
M Scott said:
Here you go. You could replace B1 with your value as part of the formula if
you didn't want to use another cell.

A1: 12/1/2007
B1: 3 (Months to subtract)
A3: =DATE(YEAR(A1),MONTH(A1)-B1,DAY(A1))
Click to expand...
 
Thanks - This was exactly what I needed!

M Scott said:
Here you go. You could replace B1 with your value as part of the formula if
you didn't want to use another cell.

A1: 12/1/2007
B1: 3 (Months to subtract)
A3: =DATE(YEAR(A1),MONTH(A1)-B1,DAY(A1))
Click to expand...
 
My situation is:

June 14, 2009 (E2) and I need to subtract 197 (F2) days from the June 19,
2009 date and the answer will be in cell G2. The answer in G2 will need to be
in the formant of February 1, 2009 (this date is just an example).

Thank You
 
It's as simple as putting:
=e2-f2
into cell G2. Format this cell as desired.

Regards,
Fred.
 

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

Subtracting dates from two columns 5
If Tuesday subtract 4 (Formulas) 3
Subtract 12 hours from date/time 6
Subtracting Dates 10
Subtracting dates in Excel 2003 3
Need formula to subtract 5hrs from date/time field 8
How do I subtract 8 business hours from a date/time value? 5
Find the position of a date 6

Back
Top