Hope you can get Excel to do it as you've made a mistake doing it by hand
:)

6 calendar months on would be 04/11/03.

Nice solution using MIN( with array - must get used to using that more.


On Sat, 08 Jul 2006 19:46:02 +0100, hoyt
wrote:

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



--
Steve (3)