Cells D3:D100 contain a list of dates (MM/DD/YYYY). Cell E1 contains the formula =TODAY() to return today's date.
The formula I want to create would compare the months of the listed dates with the month of cell E1. If the month/Year in cell D3 matches E1, Cell E3 would Type the word "Due." If the month/year was older than the month/year of todays date, it would type "Overdue."
The formula I have almost works:
=IF(D3<EDATE($E$1,-1),"OVERDUE",IF(D3<EDATE($E$1,0),"DUE",""))
The only issue is that it looks at the date, and if the date is expired by one month, it writes "Due". If the listed date in D3 is Nov 25, 2014, for example, it does not write "Due." Instead of the date and going back one month, I want the formula to look at the month and year of the date in D3 and if it is the same month/year as E1 (TODAY) then it will list "Due." If month/year of D3 is older than the current month/year, it would say "Overdue."
Thanks in advance.
Bookmarks