# Posts by dackson

• ## Finding next due date of holiday ticket

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.

• ## Finding next due date of holiday ticket

For that want to filter from the code no sir.

• ## Automatic Filtering by some specific value

HI BRO,

1, GO TO B6 COPY THIS FORMULA =IF(A6="","",IF(A6<=EOMONTH(TODAY(),-2),"NO","YES")) AND DRAG DOWN.

2. SELECT A5:B5 AND GO TO DATA TAB MAKE FILTER AND IN B5 TIK YES ONLY.

3. GO TO REVIEW TAB, CLICK PROTECT SHEET TIK PROTECT WORKSHEET AND CONTENTS OF LOCKED CELLS, TIK SELECT LOCKED CELLS, TIK SELECT UNLOCKED CELLS AND BAL ALL UNTIK AND GIVE OWN PASSWORD AND SAVE.

REGARDS,

DACKSON.

• ## Finding next due date of holiday ticket

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

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.