Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Conditional Formating between 2 dates
I know how to achieve this in excel but can't figure it out here.
We are looking to highlight a cell (or row) if the number of business days between two cells is less than 3 business days
For example in a row we have:
Date1 = 11/30/15
Date2 = 12/2/15
In this case above we would want to color Date2 red (or the whole row) since there are less than 3 business days between the 2 dates
If Date1 was 11/30 and Date2 was 12/3 then there would be no color highlight.