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