Adding 6 months to any given date
Hi
If you have the Analysis Toolpak loaded, ToolsAddinsAnalysis Toolpak
then
=EOMONTH(A1,6)
Otherwise the formula recently posted by Bob Phillips
=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))
which caters for the fact that adding 6 months to 31 March, returns 01
October and not 30 September when adding 6 months by the standard
method.
--
Regards
Roger Govier
"hoyt" wrote in message
...
is it possible to add 6 months to a given date?
i.e. if in cell A1 the date is 04/05/03, then cell B1 should return
the date
plus 6 months ie 04/12/03. the only way ive been able to get something
near
is by adding 182.5 which is half a year in days but this obviously
doesnt
account for the different months having varying amounts of days.
Any Ideas?
Regards
Hoyt
|