Finding next due date of holiday ticket

[xpost]

[/xpost]

https://chandoo.org/forum/thre…ticket.45490/#post-271442

https://www.excelguru.ca/forums/showthread.php?10972-Finding-next-due-date-of-holiday-ticket

also Mr E and https://www.excelforum.com/exc…-after-my-leave-days.html where it is marked Solved

HI all,



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,

Dackson

For that want to filter from the code no sir.

Hi sir,

In other forum it was single employee example but it is not work for me, this is absolutely new thread new example files.

Please consider and help me make the solution to me.

Thanks and regards,

Dackson.