Finding next due date of holiday ticket

[dackson]

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

 

[footoo]

=B2+E2+364

First sub=total the LOP days

 

[dackson]

=B2+E2+364

First sub=total the LOP days

I couldn't get sir.. Please

 

[RoryA]

@dackson

Please take a minute to read the forum rules, especially the one on cross-posting, and follow them in future. Thanks.

 

[dackson]

ok