How Can I Automate Tracking Employee Arrival Status in Excel Without Minute Details?

I am working on a very basic spreadsheet to track whether employees are late, on time, or early based on a specific date (not by the minute or hour). I understand it may sound unusual, but that's the requirement I have. I have a column for the expected date the employee should arrive, another column for the actual arrival date, and a status column. How can I set up the status column to automatically indicate "Late," "On-Time," or "Early" based on the dates? Any assistance would be greatly appreciated. Doing this manually is quite tedious!

Hi,

Using the "IF" function, you can obtain the status. In the worksheet, select Insert, Function, IF. Define the condition and the required output. If you still can't get it done, post your Excel file on this site.

-Vellayan