Adding 6 months to any given date
You could try this:
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"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
|