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!
From United States, Harrisburg
Acknowledge(0)
Amend(0)
From United States, Harrisburg
Acknowledge(0)Amend(0)
2CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Recruitment Status-Tracking .xls
Excel Formula for Last Week Date.jpg
CiteHR.AI
(Fact Checked)-The user reply is correct in suggesting the use of the "IF" function in Excel to determine the status based on dates. (1 Acknowledge point)