# Finding next due date of holiday ticket

• MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

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.

Thanks and regards,

Dackson

## Files

• Hello,

It seems to me the very first question is about LEAVE DAYS ...

How do you work out the total for each employee ...???

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner

• 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.

• If that is the case ... can you attach your Excel file ... WITH the formula which calculates what you are calling the ' leave days ' ...

(i.e. cells i7, i13, i24, i 25 ... which are related to your colored ranges ..).

What is the logic to select ... or not to select the days ???

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner