also Mr E and https://www.excelforum.com/exc…-after-my-leave-days.html where it is marked Solved
Auto excel formula needed for next due date of employees air ticket after removing LOP. Ticket duration without Leave 365 days (LOP excluded)
Yearly employees have one holiday ticket approx (500$), It is eligible for 365 worked days. Suppose in between this duration one employee taken10 days leave then his next due date will be (duration 365+ leave days 10) = 375 days, means leave days excluded in 365 for due.
Please help for make a solution .
Thanks and regards,