I am working with an excel spreadsheet where I'm showing the date a report was due vs. the date a report was actually completed. I want to use conditional formatting to show if a date is on time, 1 month behind, or 2+ months behind.
I'm doing pretty well using =(MONTH(A2)-MONTH(A5))<=-2, be red. Where I have a problem is going back between years. So January 2010 - November 2009 is negative 2 (-2) but it shows up as #####. Is there a way I can subtract 01/2010 from 11/2009 and show a negative number?
Bookmarks