Formula If([Date of Request])?
If date of request is less that today + 2 future days, I need my row to be red. The formula I am using is not working. Please advise.thx
Forum Discussion
If(
[Date of Request]>(Today()+Days(1)) AND [Date of Request]<(Today()+Days(6)), "yellow",
[Date of Request]>(Today()+Days(5)) AND [Date of Request]<(Today()+Days(11)), "blue",
[Date of Request]>(Today()+Days(10)), "red",
"")
Line 2 has alert symbol - the word "AND" is highlighted in yellow and the alert message reads:
column 36 > Expecting ,
Thx
[Date of Request]>(Today()+Days(1)) AND [Date of Request]<(Today()+Days(6)), "yellow",
[Date of Request]>(Today()+Days(5)) AND [Date of Request]<(Today()+Days(11)), "blue",
[Date of Request]>(Today()+Days(10)), "red",
"")
Line 2 has alert symbol - the word "AND" is highlighted in yellow and the alert message reads:
column 36 > Expecting ,
Thx
Hi Lynn,
I have just checked this formula and found the same error which you have mentioned. Try to use in a small case - and not AND. it will work.
I have just checked this formula and found the same error which you have mentioned. Try to use in a small case - and not AND. it will work.