how do I subtract time from a date to get an earlier date? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Sunny_Dreams 12/10/2007 6:53 PM PST
  Question
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
M Scott 12/10/2007 7:13 PM PST
  Answer
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Sunny_Dreams 12/10/2007 7:37 PM PST
   
 

"M Scott" wrote:

> 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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Sunny_Dreams 12/10/2007 7:38 PM PST
   
  Thanks - This was exactly what I needed!

"M Scott" wrote:

> 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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Rusty 2/11/2009 9:09 AM PST
   
  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



"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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Fred Smith 2/11/2009 10:00 AM PST
   
  It's as simple as putting:
=e2-f2
into cell G2. Format this cell as desired.

Regards,
Fred.

"Rusty" <Rusty@discussions.microsoft.com> wrote in message
news:327DD311-2B26-4DFF-8633-8C52C3B3B8C7@microsoft.com...
> 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
>
>
>
> "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.

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies