Calculate expiry dates based on months

**goldfield** · 06-06-2013, 06:32 PM

HI All,
Just wondering if some of you gurus would mind helping me with a simple formula that i can't get my head around.
I have a date in cell A1 (dd/mm/yy) which represents an expiry date. I would like to have the word "expired" appear in cell A2 based on a formula which would subtract a number of months. eg. If the date in A1 is older than 10 months ago based on todays date then "expired" in A2. I imagine this would be based around the today() formula but i can't quite get it to work for me.

Many thanks in advance.

**daddylonglegs** · 06-06-2013, 06:37 PM

You can get 10 months before today by using EDATE so you could use this formula

=IF(A1<=EDATE(TODAY(),-10),"Expired","OK")

In Excel 2003 EDATE requires Analysis ToolPak to be enabled, an alternative is this

=IF(DATEDIF(A1,TODAY(),"m")>=10,"Expired","OK")