Formula indicating Expired

[euwest30]

Hi

I'm trying to set up a formula in a cell that will highlight a date for a welder who has been qualified for welding, but is valid for 6 months. There is a date of record when he was qualified say 1/12/2009, but I have another column that I have added to say that it has expired (in Red) ie 30/06/2010. Put it simple, I'd like a cell to say that it has expired, or if it's not expired, to just show the date of expiry.

Regards

[davesexcel]

try this
=IF(DATE(YEAR(A11),MONTH(A11)+6,DAY(A11))<TODAY(),"Expired",DATE(YEAR(A11),MONTH(A11)+6,DAY(A11)))