Skip to main content
Question

If statement for future and overdue dates

  • June 17, 2022
  • 0 replies
  • 82 views

Forum|alt.badge.img+5
I want to color code based on due date.

Green = On Track (11 + days in future)
Yellow = Due Date is within 10 days
Red = Overdue is after the due date.

I was able to get my formula for green and red to work but my yellow is not working.  If it is supposed to be yellow, it is actually turning green instead.

Any help would be greatly appreciated,

Thanks,
Sandy

------------------------------
Sandralee Oster
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
Can you post your current formula? Then we can correct it.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------