#82-How to Make Automated Attendance Sheet in Excel - Step by Step Tutorial

tqvm .... i m follow this step by step till success to complete it.

How to add new person in this table

Thank you for making it in English. This sooo helpful

Hello, I like that excel! How can I make the year rollover. If I want January 2024 rolling over automatically , How can I make that happen? Thanks

Hello sir. I want to know what did you do when you change the month the data that you input will stay the same:ex Feb then you switch next month and I want to stay the data I input in the Feb month even that you switch in another month.

Thank you so much, very helpful.

Fantastic it helped me a lot. Thank you

Sir i have one problem kab hum sun ke liye conditional formatting krte hain uske baad data validation mai jakr sun mai data validation krne ke baad jab hum p or A mention krte h then change the month to sir sun mai bhi p or A apne app a rha h to sir ye solv kese kre

❤❤❤❤❤❤

Sukran. Thanks a lot. AssalamuAllaikom

Pls.make in hindi with payroll

Nice ❤

Nice video. Can we include late marks in this??

What if year change on 2023 last day? The whole sheet does not depend on year

Hi, thanks for sharing this video, which formula other than data value I can use to select the year of my preference and not the computer system year? I appreciate your help.

I want to make Saturday and Sunday days off, how do I do that?

Thank You

sir, how can change year ?

Sir explain again view code function

Hi sir i want to ask if we change the months n year for the next month the data will lost or not

Do you happen to have this format for keeping employee time?

Formula r to t pls

Where is the code??

Hello sir, from where i will get a code form

Hi thanks for this awesome vid.. Here in philippines we have many kinds of holiday.. trying to set regular holidays, special nonworking holidays and special working holidays.. how do i set this in the same timesheet? with conditional formatting as well.. i'm kind of stuck. trying to copy what you do.

So Nice video 💝

For every month the attendance is calculated but how the casual leave, earned leave, medical leave, will be calculated for an year will be calculated

How comes 23 day present if 22 full day and 1 half day present it should be 22.5

excellent but i have one doubt about how to create the Xcel sheet code for copying the sheet

It's easy to make attendance sheet for a common holiday. But if Different employee have different offday (Holiday), How can you do attendance sheet for them?

where did you get the code from?

Would you mind doing one for students attendance?? With 4-5 subjects and linked tgt and show it as weekly and monthly as well. And also what if there's a replacement classes?
It would be a great help.🥺

Thank you very much from Myanmar.

Very helpful - thanks

I just making 2022 attendance sheet but holidays is not shown any months after putting iferror formula...what to do

Im trying to add the function for holidays but not getting any luck. Its all N/A no matter the month i chose. Please help

When I am entering data validation months it is showing "A named range you specified cannot be found" Pls help

Hi , this is very helpful, I kindly would like to know the formula for when the (P)day is for Sat & Sun? To count both

I have learned so much from your video! so Thank you very much!. I want to ask you about something, can you make the attendance taken in January stay only in January and not move to feb? in another words, i do not want to use clear and copy buttons, i want to change the month and get another empty cells spcifically for that month. Can you do that please!!

Nice

Dear sir, =countif(holidays,c$6) is not working in my system window 13

nice video

Thanks for The Video Sir, if anyone feels like giving up on this ...it actually works

Not able to download file

How are am I going to know what code to put?