vendredi 7 mai 2021

Attempting to create excel database that flags a date (90, 120, 150) from a date column and produces an input "SOMETHING IS DUE" in another column

The current IF statement I am attempting is:

=IF(D4<=TODAY()-90,"AWARD DUE",IF(D4>=TODAY()-91 AND D4<=TODAY()-120,"INPUTS DUE",IF(D4>=TODAY()-121 AND D4<=TODAY()-150,"PREPARE INPUTS","")))

but excel will not run the program and states, "There's a problem with this formula."

I am having trouble figuring out what the issue is and how to fix it. Any help in the right direction is appreciated. Thank you!

Aucun commentaire:

Enregistrer un commentaire