Absence tracker including weekends but need a line of formula that overrides weekend

[Prabhu_Churi]

=IF($B9="","",IF(D$8="","NA", IF(@INDEX(T_EMP[START DATE],ROW(B9)-ROW($B$8))>D$8,"NE", IF(AND(@INDEX(T_EMP[END DATE],ROW(B9)-ROW($B$8))>0,@INDEX(T_EMP[END DATE],ROW(B9)-ROW($B$8))0,"HOL", IF(@INDEX(L_WKNDS,WEEKDAY(D$8)),"WKND", IFERROR(@INDEX(TableLeave[LEAVE TYPE],SUMPRODUCT(--(TableLeave[EMPLOYEE NAME]=$B9),--(TableLeave[START DATE]<=D$8),--(TableLeave[END DATE]>=D$8),ROW(TableLeave[LEAVE TYPE]))-@ROW(TableLeave[#Headers])),"Work") )))))) If anyone thinks they may be able to help please let me know.

 

[Fluff]

Duplicate to: What if the employee works in holidays or in weekends?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.