How do I Subtract 6 months off a date in excel

[Geoff]

Hi

Just wanting to subtract 6 months off any date, and present in the format of
a date.

Cheers

 

[T. Valko]

Assume you have a date in A1.

=DATE(YEAR(A1),MONTH(A1)-6,DAY(A1))

 

[JE McGimpsey]

One way:

A1: <date>
A2: =DATE(YEAR(A1),MONTH(A1)-6,DAY(A1))

Note that A1= 12/31/2008 will return 07/01/2008 in A2 since June has onl
30 days (US formatting).

 

[John C]

If you have the analysis toolpack installed
=EDATE(yourdate,-6)