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