Hi All,
I am trying to create an if statement with an embedded date formula in col B, which takes the difference between today's date and another date (F3), where the date in F3 is also derived from a formula.
If F3 minus today's date is less than 11, the cell should return "AMBER". This is giving me an error, saying there is a problem with this formula. See attached. Just remove the single quotes around the formula in cell B3 to activate it.
=IF((F3-TODAY())>11)), "AMBER","FALSE")
Ultimately I want to build a series of embedded if statements where, greater than 10 days to go returns GREEN; between 10 and 0 days to go returns AMBER, and less than 0 days (overdue) returns RED.
Thanks a lot
Bookmarks