• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Finding next due date of holiday ticket.

Status
Not open for further replies.
Dackson

Dackson

Member
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
 

Attachments

  • NEXT HOLIDAY DUE.xlsx
    11.8 KB · Views: 1
Dackson
Why did You duplicated Your thread?

Finding next due date of holiday ticket

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...
chandoo.org
This thread is closed.
 
Status
Not open for further replies.
Back
Top