mercredi 29 septembre 2021

IF Year(today) is x years greater than Year(A1) Then

I am struggling to get this formula working.

If the current year minus the year in A1 is greater than 50 years, then yes, otherwise no

=IF((YEAR(TODAY)-YEAR(F13)>50), yes, no)

Aucun commentaire:

Enregistrer un commentaire