mardi 26 janvier 2016

Excel Formula for less than 60 but greater than 30

My current excel formula is:

=IF([DVT Contract End Dates Days Left]<=0,"Expired",IF([DVT Contract End Dates Days Left]<60,"Expiring soon",""))

Please assist me with modifying this formula so that it excludes any days that are less than 30 and only keep days that are greater than 30 which will be marked with Expiring Soon.

Much appreciated :)

Aucun commentaire:

Enregistrer un commentaire