I am trying to create a formula for comparing column H to column I for OTD Metrics. H = Due Date and I = Receipt date. I would like it to state "Late" if the receipt date is past the due date or "on time" if the receipt date is on/or before the due date. There are 329 lines. Thanks!
Due Date | Receipt Date |
04/09/21 | 04/05/21 |
04/05/21 | 04/05/21 |
04/21/21 | 04/20/21 |
04/22/21 | 04/14/21 |
04/21/21 | 04/21/21 |
04/21/21 | 04/21/21 |
04/21/21 | 04/21/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |
04/14/21 | 05/03/21 |