J
JonMAd
Hi All,
I am trying to make a cell change colour 1 month before a date becomes
overdue to flag it for attention. I can do this without worries for a 6
month review, but a 12 month review will not change, it will change format
when it becomes overdue.
I am using
=IF(TODAY()>=$C11+153,1,0) to change it 1 month before the 6 month
expiration date &
=IF(TODAY()>=$C11+334,1,0) for 12 month. I seem to recall that Excel only
allows for 300 days in year calculations? Is that the problem and is there a
way to get around this. Thanks in advance.
I am trying to make a cell change colour 1 month before a date becomes
overdue to flag it for attention. I can do this without worries for a 6
month review, but a 12 month review will not change, it will change format
when it becomes overdue.
I am using
=IF(TODAY()>=$C11+153,1,0) to change it 1 month before the 6 month
expiration date &
=IF(TODAY()>=$C11+334,1,0) for 12 month. I seem to recall that Excel only
allows for 300 days in year calculations? Is that the problem and is there a
way to get around this. Thanks in advance.