If that date is 1 month behind today's date, the output needs to be - "1 Month Behind"
If the date is 2 months behind today's date, the output needs to be - "2 Months Behind"
If the date is 3 (or more) months behind today's date, the output needs to be - "3 Months or More Behind"
If the date is blank, then the output needs to be - "Blank"
If the date is after today's, or future, date then the output needs to be - "Up-To-Date"
I have a semi functional formula working which is attached in the spreadsheet. The problem is that in A8, I have a highlighted date. Technically, the formula is correct, but that's not what I needed. 5 is two less than 7 so the output should be "2 Months Behind".
Thanks in advance.
Bookmarks