- Registration date
- Monday August 16, 2010
- Last seen
- February 9, 2021
BethanMary4, Good morning.
Maybe this is about of separator sign of your system:
Try to use COMMA ( , ) instead of SEMICOLON ( ; )
Old --> =AND(TODAY()-N1<=42 ; N1-TODAY()<=42)
New --> =AND(TODAY()-N1<=42 , N1-TODAY()<=42)
Please, tell us if it's working now.
I hope it helps.
Belo Horizonte, MG - Brasil.