Hello sir thanks for such an informative video. Sir I created an attendance sheet same as u explained in this video but sir if i change any months attendance the whole months attendance changed on same time.. Kindly help 😢
Sir, lm from Pakistan. I really appreciate your work. I would like to ask you, if suppose i want to apply restrictions on Saturday and Sunday, how can i do it using formula in data validation. Also please teach me how can i highlight Saturdays and Sundays in a month. Thanks, waiting eagerly for your reply.
Bohat khoob amazing! mujhe bohat kuch seekhny ko mila! Sir mery pas aik error show ho rha hai ke ynha jo hazri hum 1 month main lga rhy hain whi same tmam month main show ho rhi hain saem 1st month same 2nd month. please iska koi halll btain Thanks! Mujtaba Malik
Nice video. I have one doubt. If we filed present and absent details for a month.... the same filled details coming whn we r changing the month. Is there any solution for that?
Same problem jab month change krty Hain to last month me Jo record save Kia hota h wohi show hota ha or absent present leave me bhe last month ka record ata ga
AOA. I have created the sheet and is working fine. But when I am using "1" instead of "P","A" or "L" my calendar does not clear the cell like it does in your video for the month that is 30 days. How to fix this so that calendar has a clear cell.🤔
sir isme attendance banaya lakin months chainge karejab attendance chainge nahe horaha hai same attendance rahera sab months me usko kaisa salve karna ?
sir ye sheet lock kaise hogi jaise May 2023 ke attendence bnai h fr jb june change krte h to same entry aajata h or jb dlt krte h to May ki bhi entry dlt hojati h
Bro I need your help. I have also this typed of 12months single sheets. But I have an issues when I'm entering data any particular month. And then when I changed the month it has not keep saved my precious month data. It was shuffle. So my concern is how I keep saved data for each month. Even I changed month it will not effect my previous month data. Pls help if you know.
Masla hai sir ek jo aap formula likhty hain dikta hi nhi ..screen ko thoda zoom out kr den to bat bn jaye ...baki sab bahut badhiyan se samjhaya apny ..so I subscribed in first watch
dear sir when i completed this sheet but in this I faced a two issues 1. data is not recorded and 2. I wants that sunday is already off but from me Saturday is not off
A.O.A bhai how r u....hope fine......mai ne ap ki ye video dekh k google sheets pe yehi setting lagai hai....but jo data january mai add krta hu wo next har month mai auto show ho raha hai....pz help me out
Sab set ha but jb is me attandance lagaty Hain to JB hum month change krty Hain Jese mene May me full attandance lagwa di absent bhi kuch kuch or kuch kuch leave bhi Laga di But Jese me month change krti hon Jese November select krti hon to same hi attandance us me lag jati Hai Jb K alag alag honi chahae sb month Ki attandance na sir
Hello. Is there a formula that can make a total number of person per day(at the end of the number of person per day) will become blank, if it falls saturday, sunday, or holiday or breaks, or no class? Additional information Sir, if it falls on the day that is not a holiday, sunday, or saturday, the result is the number of persons present on that day.
SIR JAISA MAINA JULY KI ATTENDACE LAGANI HA SO MARA PORA MEHENA KI ATTENDACE LAGALI TO MA EVERYTIME SAVE KRUGA YA SAVE AS AGR MA SAVE KRUGA TO MERA JAISA NEXT MONTH AUGUST HA TO TO MERA JULY KA DATA SAVE RAHAEGA KA NHI
A.o.A boht acha or asan samjhaya apny ak or help chaheya main monthly Summary sheet bnata hun to us main working hours likhty hen or friday over time hota ha or main chahta hun k basic hour sy zyada time agr likhen to wo over time waly colum main automatic ajaye jasy 1 din k basic 8 hour hen agr koi 10 hour work karta ha ya friday duty 10 hour ya 5 hour karta ha to wo over time waly colum main ajaye kya ap meri help kar sakty hen
Over Time Calculate krne k liye aik alag se video banai ha is ka link ap k sath share kr raha hn ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GJEOiAnwv2U.html
Sir total hour or over time to nikal liya mgr normul time count karna parta ha is ka b koi formula ha to kindly bata den sir basic 10 hour hen ak month k 260 is main agr koi chuti karta to kum ho ga to is ka koi formula bata den kun k main total hour py sum ka formula laga diya or over time main total hour - normal over ka formula laga diya just normal time wala formula chaheya
Assalamualaikum aaj mujhe zarurat padi hai Sahab her mahine ki 16 se 15 tak ki attendance ki sheet banana chahiye ager possible hai to Pura bataiyega salamualaiku
Sir month change kar rahe to date aur day dono change ho raha but jo data September me bhar chuke hai. Aur month change karne par data nahi change ho raha
Overtime calculate krne ka liye Alag se sheet banai janati ha. Jis din b ap extra hours company ko dain gy wo us sheet me record Kia Jay ga. Extra working hours ko calculate krne ka liye Mene video banai ha . Is link per click kr k ap video dekh sakty ho ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KC2rKmrw6OY.html
Yah to automatic change ho rahi hai lekin jo attendance Lagate Hain Na vah Usi mein bhi vahi hai agale mahine mein bhi vahi hai vah Nahin dikhna chahie na Jis mahine ki Banaya usmein PDF Mein sev Ho Jaaye FIR agale mahine ki banae to Usi Mein Wapas Nahin serial se entry ho jaaye