Attendance spreadsheet assistance

Welcome to the forum.

Try this in G4 in your tracker tab:

Formula:

Please Login or Register  to view this content.

And that same formula adjusted to cell L20 in your calendar tab:

Formula:

Please Login or Register  to view this content.

Good luck!

Estevaoba, you are a amazing!!! that did it !! omg thank you soo soo much!

do you know if i am able to combine the employee leave tracker under the calender vie but for only one specific employee at a time. and when i change the name in cell c2 it changes with the new employee? or does it need to be in a different tab for the calendar to update with the tracker?

Estevaoba, you are a amazing!!! that did it !! omg thank you soo soo much!

do you know if i am able to combine the employee leave tracker under the calender vie but for only one specific employee at a time. and when i change the name in cell c2 it changes with the new employee? or does it need to be in a different tab for the calendar to update with the tracker?

Hello, Kathleen. You're welcome.

This formula in cell C20 in your calendar tab will replicate data from cell C4 in your tracker tab.

Formula:

Please Login or Register  to view this content.

The formula could be copied across to the other columns, but your merged cells make it difficult, so I had to undo merge, copy paste formula to next column one at a time, and then merge them back.
That will do for only one row of data. If more events, therefore, more rows are required, we'll have to come up with a different solution.