Calculation Formula Please help

[Amine008]

Employee-Leave-Vacation-dashboard.xlsx

Hey Folks, Please I need your help to fix one issue in the attached excel file.
Sheet [FONT=&quot]TEAM DASHBOARD, I want to add INT fuction to calculate only date from vacation & absence sheet without time. I'm looking also to get data from the 2 table ( Vacation & absence) this will help me to track attendance for employee.

Really need your support here.

Thanks
A[/FONT]

 

[Amine008]

Hello - any help please ?

 

[Tetra201]

Please keep in mind that some forum members are unable or unwilling to download files from file-sharing sites.
The best approach would be to post a small example of your data.

 

[FDibbins]

Also, it would help if you told us what your data is, want you have tried, and what you want

 

[Amine008]

Thanks for your reply. actually with this formula : IFERROR(IF(D$7="";"NA";IF(D$7<INDEX(T_EMP[From Date];ROW($C8)-ROW($C$7));"NE";IF(AND(INDEX(T_EMP[TERMINATION DATE];ROW($C8)-ROW($C$7))>0;D$7>INDEX(T_EMP[TERMINATION DATE];ROW($C8)-ROW($C$7)));"NE";IF(NOT(ISERROR(MATCH(D$7;L_HOLS;0)));"H";IF(INDEX(L_WKNDVAL;WEEKDAY(D$7;1))=1;"WKND";INDEX(Table_owssvr[Attendance Employee];SUMPRODUCT(--(Table_owssvr[Agents Name]=$C8);--(Table_owssvr[From]<=D$7);--(Table_owssvr[To]>=D$7);ROW(Table_owssvr[Attendance Employee]))-ROW(Table_owssvr[#Headers])))))));"").

I can track attendance from sheet vacation and I want to have the same thing by adding data from sheet absence.
To resume in the 2 sheets I have different type of attendance for the same employee and I want to track this team dashboard sheet.

Also, it would help if you told us what your data is, want you have tried, and what you want

 

[Amine008]

The name of the second table is Table_owssvr7