Dear Experts
I have just made a simple attendance Sheet.
Attached sheet has a tab named Holidays and Attendance.
In the attendance, based on date and Month in Holidays I am updating Column AH.
Example, In Jan 2021, there are two days in Holidays. That is 14 and 26. In Attendance tab, if there is value "P" on 14 and 26 I am updating AH with Value 2
Is there anyway to automate this
Bookmarks