Hi

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

Cheers

Assume you have a date in A1.

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

--
Biff
Microsoft Excel MVP


"Geoff" wrote in message
...
Hi

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

Cheers

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).


In article ,
Geoff wrote:

Hi

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

Cheers

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


"JE McGimpsey" wrote:

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).


In article ,
Geoff wrote:

Hi

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

Cheers

How to subtract 6 months off a date in Excel:

1. Select the cell where you want to display the new date.
2. In that cell, type the formula
   Code:

   =EDATE(A1,-6)

   (without the quotes).
3. Replace "A1" with the cell reference of the original date you want to subtract 6 months from.
4. Press Enter.
5. The new date will be displayed in the selected cell in the format of a date.

That's it! The function in Excel allows you to add or subtract a specified number of months from a date. In this case, we used "-6" to subtract 6 months from the original date.