Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

Please help me with this nested formula! Thanks :)

Posted by Jim Jankowski on November 19, 2001 1:34 AM

I have spreadsheet which has expiration dates on items. If there is an expiration date in F the word approved shows in column G. If it's within 60 days of expiring the word "Expiring" appears in column G. I would like the word expired to appear when the item actually expires. Here is the formula I'm using now. Does anyone have any suggestions how to add the "Expired" factor into this nested formula?

=IF(ISNUMBER(F22),IF(F22<=TODAY()+60,"Expiring","Approved"),"")

Thanks for your help.

Re: Please help me with this nested formula! Thanks :)

Posted by Paul Akkermans on November 19, 2001 1:50 AM

=IF(ISNUMBER(F22),IF(F22<=TODAY()+60,IF(F22<=TODAY(),"Expired","Expiring"),"Approved"),"")

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.