# Finding next due date of holiday ticket

• [xpost]

[/xpost]

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

## 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 "Smiley" icon, below, in the bottom right corner

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

• 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 "Smiley" icon, below, in the bottom right corner

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!