Hi,
I am trying to use the following formula:
=IF[Due Date] <=7, "Red",
IF[Due Date] > 7 and <=14, "Yellow")
IF [Due Date] > 14 and < 30, "Green")
How do I do that, I tried to create a new column to show the colors, but I keep getting Invalid Operation.
=IF(([Due Date]1) > 7, (AND([Due Date]1) < 14), "Red"),
IF([Due Date]1) > 14, (AND([Due Date]1) < 30), "Yellow"),
IF([Due Date]1) > 30, "Green")
Any help is much appreciated!
Thank you,
Deepthi