Dear Experts,
I'm able to do formula for the straight dates, now i need to have condition that if the 4-days/32hrs of scheduling is done, the next task should take the scheduling date after 4-off days.
I've updated the attached excel sheet to show sample data and expected outcome for reference to my problem.
I want to calculate the dates based on the hours scheduled daily. 8-hrs worked is considered 1-day, after completing 4-working days an employee will have 4-days off in the schedule and the next schedule date should be after the 4-off days/32hrs.
Please i need help in this regards, Thanks!
Bookmarks