LinkBack URL
About LinkBacks
I'm assuming A1 is your expiry date?
This should do what you want it to...
=IF(DAYS360(TODAY(),A1)<0,"Expired",IF(AND(DAYS360(TODAY(),A1)>0,DAYS360(TODAY(),A1)<10),"Soon to Expire",""))
I'm assuming A1 is your expiry date?
This should do what you want it to...
=IF(DAYS360(TODAY(),A1)<0,"Expired",IF(AND(DAYS360(TODAY(),A1)>0,DAYS360(TODAY(),A1)<10),"Soon to Expire",""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks