Hello all, i did i quick search to see if this issue has already been resolved and couldn't find anything.
My issue is as follows:
I need a calculation that will do the following:
Compare today's month/year with the expiration date provided. If it is less than 2 years away, Use that date. If it is greater than 2 years, then use today's month/year +2
I can't figure out what function to even use
IF(YEAR($D$11)>=(YEAR(TODAY())+2),TODAY()+YEAR(2),$D$11)
Thats what i have so far, needless to say it doesn't work. Can you steer me in the direction of properly using date data?
Bookmarks