Hi
On the attached document, Im having trouble with the formula in cells C5-I5. Essentially, I want it to display text (in this case ASAP U R G E N T) in the cells if the day chosen via the calendar in B5 is less than 60 days from today, if it is greater than 60 days I want it to post a day/date/month. My formulas for both seem to be correct, but the spreadsheet isn't choosing one of the other based on what is chosen in B5.
Here is an example of my formula in C5
=IF(B5<TODAY()-60,"ASAP",IF((B5-150+150)=0,"",B5-150))
I'm using the 150 to denote days after the date inputted in B5 to calculate a date (which is working well).
Any ideas?
I've attached the spreadsheet as well.
Bookmarks