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?
Aucun commentaire:
Enregistrer un commentaire