Comparing dates and returning a RYG ball

Deborah R

Can someone tell me what is wrong with this formula:

= IF(TODAY() - ["DUE"2] > 0, "Red", IF(TODAY() - ["Due"2] > -3, "Yellow", "Green"))

I am trying to compare today to a due date and return the appropriate ball.

 

Thank you.

J. Craig Williams

Deborah,

 

1. Column name references require the square brackets [] around them if the name contains special characters, spaces, or ends in a number.

 

2. If the actual column name does not contain quotation marks, you should not use them.

"DUE" is a valid column name if the name really has quotes around them.

If the name is just Due, then no quotes are needed to reference it.

Side note: Column names are case-insensitive, so DUE and Due will be changed in your formula after you type it to the correct case to match the real column name.

 

3. Cell references are ColumnRow like this: Due2 or [Due Date]2 but not [Due2]

 

I think this may be what you are looking for:

 

=IF(TODAY() - Due2 > 0, "Red", IF(TODAY() - Due2 > -3, "Yellow", "Green"))

 

Hope this helps.

Craig

 

 

 

 

 

Deborah R

Craig--

Thank you. It works like a charm.

Deborah