I’m trying to do a logical test on the following<o></o>
Say I have todays date in cell A1 in Cell B2 I have the date of the next calibration with a logical test written if before date in cell B2 “OK” and after date “Over Due”. I have been trying to write a logical test to warn me that within 30 days I will need to action.<o></o>
So the cell look like this “OK”….”Action”….”Over Due”<o></o>
<o> </o>
Thanks in advance.<o></o>
Say I have todays date in cell A1 in Cell B2 I have the date of the next calibration with a logical test written if before date in cell B2 “OK” and after date “Over Due”. I have been trying to write a logical test to warn me that within 30 days I will need to action.<o></o>
So the cell look like this “OK”….”Action”….”Over Due”<o></o>
<o> </o>
Thanks in advance.<o></o>