Комментарии:
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?
Ответить