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