Formulating Dates

[Robin]

How do I create a formula to add 6 months to any date in a
column?

 

[Frank Kabel]

Hi
try:
=DATE(YEAR(A1),MONTH(A1)+6,MIN(DAY(A1),DAY(DATE(YEAR(A1),MONTH(A1)+7,0)
)))

See: http://www.cpearson.com/excel/datearith.htm

 

[Guest]

I copied and pasted the formula and it says #Value!

 

[Guest]

Thank yoU! It worked/

-----Original Message-----
Hi
try:
=DATE(YEAR(A1),MONTH(A1)+6,MIN(DAY(A1),DAY(DATE(YEAR (A1),MONTH(A1)+7,0)
)))

See: http://www.cpearson.com/excel/datearith.htm

--
Regards
Frank Kabel
Frankfurt, Germany



.