Howdy,
I am working with the following formula in my spreadsheet.
=IF(ISBLANK(F3),"Never Reported",IF(OR(MONTH(TODAY())<MONTH(F3),YEAR(TODAY())<YEAR(F3)),"Not Reporting","Reporting"))
F3 has a formula in that cell as well which reports either a date or blank.
When a date is in the cell the...