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

Thanks and regards,
Dackson

#### Attachments

• 11.8 KB Views: 1

#### vletm

##### Excel Ninja
Dackson
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.

HI ALL,

Dackson

#### vletm

##### Excel Ninja
Dackson
• 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.

#### AliGW

##### Active Member
This has been cross-posted on Excel Forum, OzGrid, Mr Excel and XGuru to my knowledge.

#### pecoflyer

##### Active Member
Has been solved on cross posts

Dackson