If I have a date in Cell A1, what formula do I need to put in cell B1 to subtract 6 months.
eg If A1 = 14/08/2007 I want B1 to read 14/02/2007 and not 12/02/2007 which it reads when subtracting half a ywears worth of days
Try this:
Code:=A1-(DATE(0,7,0))
Try
=DATE(YEAR(A1),MONTH(A1)-6,DAY(A1))
If I have a date in Cell A1, what formula do I need to put in cell B1 to subtract 6 months.
eg If A1 = 14/08/2007 I want B1 to read 14/02/2007 and not 12/02/2007 which it reads when subtracting half a ywears worth of days
With the Analysis Toolpak active...
=EDATE(A1,-6)
=DATE(YEAR(A1),MONTH(A1)-6,DAY(A1))