olimajor123
Board Regular
- Joined
- Nov 13, 2013
- Messages
- 72
Hi,
I am trying to use the IF formula with some variable dates and have tried a few combinations but have been unable to get it to work correctly for all the cells yet.
Basically I have two columns titled 'Due Date' and 'Cleared Date' and a third blank column. In the third column I want to compare whether the job was cleared before, after or on the due date. I have about 1000 rows so needless to say I don't want to do this manually!
Any help is appreciated.
Thanks
I am trying to use the IF formula with some variable dates and have tried a few combinations but have been unable to get it to work correctly for all the cells yet.
Basically I have two columns titled 'Due Date' and 'Cleared Date' and a third blank column. In the third column I want to compare whether the job was cleared before, after or on the due date. I have about 1000 rows so needless to say I don't want to do this manually!
Any help is appreciated.
Thanks