Hello Once More...
Is it possible to compare only the month and the day of formulas? For example,
I have a date in a1: 5/4/1984
The idea is to show the value as true if the month and day are greater than todays month and day and show False if the opposite occurs.
I have this formula but it doesn't work.
=IF(MONTH(A1)&DAY(A1)>=DAY(TODAY()+1)&MONTH(TODAY()+1),"True","False")
It still comes up value as true even though the month and day have passed.
Bookmarks