mercredi 5 mai 2021

Excel function IF + today

I was trying to figure out what is wrong and how to change this function which seemed to be working fine last year but now it doesn't.

=IF(YEAR(D31)=2021,"Tested",IF(E31-TODAY()<0,"testing date expired",IF(E31-TODAY()<30,"testing required this month"," ")))

E31 is =D31+91 so it gives date 10-05-2021

The purpose is to show that if testing day is coming, column G should show "Testing required this month" and this should be shown but instead it shows "Tested". Any ideas what is wrong here?

enter image description here

Aucun commentaire:

Enregistrer un commentaire