I have two excel sheets. One like below:
Sheet 1:
Column 1 Column 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Sheet 2:
Column 1:
On Time: xx
Not on Time: xx
So example.
If date 1 is greater than date 2, then it should add 1 to the "Not on time" row. And if date 1 is less than or equals date 2, then it should add 1 to the "On Time" row.
Please note that I have two different sheets in the same workbook
How can I achieve this?
Aucun commentaire:
Enregistrer un commentaire