• 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

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: 2
Dackson
Did You notice one written rule about Excel Challenges-threads?
Post an Excel related Challenge for others to Solve (You must have a solution) Don't post questions here!
Moved to Ask an Excel Questions.
 
Dackson
Please reread Forum Rules:
  • PLEASE DON'T SHOUT! We have big ears and will hear you just the same.
  • Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight.
 
This has been cross-posted on Excel Forum, OzGrid, Mr Excel and XGuru to my knowledge.
 
Dackson
For next Your thread, please reread Forum Rules
Those are for You too.
 
Back
Top