Hello - I am looking for a formula that will return "A" if the date in B5 is equal to or less than a year ago, and "B" if the date in B5 is greater than 1 year ago
So far I have:
=IF(C5>=DATE(YEAR(B4)-1,B4,B4),"A","B")
C5 is a date that varies
B4 is today's date =TODAY()
It returns: #NUM
Thank you in advance
So far I have:
=IF(C5>=DATE(YEAR(B4)-1,B4,B4),"A","B")
C5 is a date that varies
B4 is today's date =TODAY()
It returns: #NUM
Thank you in advance