Thread: how do I subtract time from a date to get an earlier date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
M Scott M Scott is offline
external usenet poster
  
Posts: 20
Default how do I subtract time from a date to get an earlier date?
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))

"Sunny_Dreams" wrote:

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.
Reply With QuoteReply With Quote