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 😢
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
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.
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
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
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
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.🤔
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
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
sir isme attendance banaya lakin months chainge karejab attendance chainge nahe horaha hai same attendance rahera sab months me usko kaisa salve karna ?
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.
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
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
I need help I want end date between month i.e if my attendance start date is 10th Jan 2024 and end date 10th Feb 2024 Is there anyone to know the formula
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
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.
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
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
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 ruclips.net/video/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
Behtreen.. Excellent
Ap ne nahayat hi easy tariqy se samjhaya.Noce
Bahut aasan tarike se sikhaya haai .. bahut hi badhiya video
Mashallah That's Great. I love it because I have been searching such type of format to make an attendance sheet
You are a great teacher sir.
Thanks
I have same query about entering data on on sheet is also displaying on another, kindly give solution
@@aaosikhainkya thanks present,absent,leave all month same
Sir apki.vedios bht achi hti hain smhj aati hai
Thanks
@@aaosikhain Sir.apsy contact krna hai
Well Done I first Time Create Attendance Sheet , Your way of explaining Method is so Simple and Clear , I really Appropriate your my Dear
Thanks
Good information bro keep Carry on
Excellent work
Awesome 🎉🎉🎉.
Bahut sahi sir
Bhai jawab nhi jabeedast it's very easy
wow great 😎
Thanks 😊
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 😢
Nice if you share the Excel sheet link it is more helpful. Informative video shukran❤
Apki video sy mujhy excal sekhny ka shok peda ho gaya boht asan thanx
Thanks
@@aaosikhain AOA SIR CAN WE GET THIS TEMPLATE IN EXCEL PLEASE?
Sir you are a great teacher can you please help me with adding to week offs to dis Excel like Saturday and Sunday both
I have the same problem. Plz educate me if you know.
Hi. Need a help. I have prepared the sheet. But now issue is when i enter attendance data in one month same data is showing in all the months
Same problem here
Yes same problem here
Same here
Tell solution
Same yrr
Awesome 👍 sir
This is awesome ❤
its a very easy I try it make my Labour salary records & then repeat comments
Bht alwaa sir
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
Badhiyan hai ji
Thanks Bhai
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.
Usefull❤
Well Done I first Time Create Attendance Sheet, but am facing problem in attendance colon,moreover it not show present in this row it show down row
sir if ky bad jo 2 value sath lgani hn beach m F4 lgana ha kia?????
Nice vedio Sir
Excellent
Thank you Bro
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
Same problem😢😢😢
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
Same problem! Did you manage finding the solution for this please?
Bhai Sunday aur holiday & per day 2-3 hrs Ka overtime ke Saath ek file bana Kar dikhao please
Aoa when I change month coumn values do not change it was entered for September but same values in columns shown in other months
Change 1 date format cell to Date format than it will change
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
ruclips.net/video/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
Thanks
Sir Attendance percentage kasy attached krain gay 12 month year by year ka sath ay ....
Automatically every month or every year Ka sath ati jay...... Please guide me😢
Good
Sir i am facing problem in employee name ke baad date nhi aa rahi if function lagane par
Great sir
Thanks Bhai
Sir g es my overtime kissy add ho 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 ek problem hai ham kis mahine pe jo attendance lagaa rahe hai oo sab pe aa raha hai
Aslam u Alikum sir kia ya attendance sheet ko aik computer ma bna ka ksi or computer ma chala sakty ha pdf ka zaria.
Bai jan is page ko 1 page par print kar skte hein
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
Thanks Bhai. InshaAllah next video me ap ko issue nahi ho ga
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
sir isme attendance banaya lakin months chainge karejab attendance chainge nahe horaha hai same attendance rahera sab months me usko kaisa salve karna ?
GREAT ! HOW WE SAVE EERY NONTH DATA FOR FUTURE USE
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.
GREAT !!! WHERE CAN I DOWNLOAD THE TEMPLATE
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
Excel kitne months me complete seekh jata hai .yani kitne months course krna parega
Depend on you
Fill kiya hua attendance next month me aa rha h iska solution batayiye nahi to is ka koi mtlb nahi ye video faltu ho jayega tbto
Mera ctrl 1 bala work nhi kr raha start date per plz koi bataye ye kaise hoga isake alawa ctrl 1 ke alawa kanha milega bo list
Sir Agar January Mn P A L type krty hn same Other month Mn wahi type hora
I mean Har month ka Alag alag data show ho
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 ek problem Hai agar hum may month me attendance fiil karte hai to same other month me bhi wahi fill ho jata hai why
If I need overtime for all employees in a column then how can I add a formula n which one formula can I use for that
I need help I want end date between month i.e if my attendance start date is 10th Jan 2024 and end date 10th Feb 2024
Is there anyone to know the formula
Bhai when we are updating in June attendance same thing is applying for next month also can you please help here
Same problem absent , Leave All month same
Please solution
Elective subjects ka kis tarah banayengy plz guide me
Sir how to merge rows Sunday only
attendance make need sheet with time in and timeout and overtime and Late then you make Present and absence then you make monthly Salary.
Sir date value lane par sell me sidha error aa raha hai
Bhai mujhe aesa video chahiye ki jis mhine ki data entry kre vo pdf file me save ho jaye or bad me usi sheet me agle mhine ki entry ho jaye
Sir pl help me to make attendance of 130 guards as rotation on 6 present 1 rest not weekly, pl help ke
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
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 main jb data validation main jta hon r source py jany k bd sheet select nh ho rhi plz batin
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
Sir how to add two week offs
Sir ji month change karne pe data change nhi hota same aaaya he uska koi upaye batao
Same query I have
Sir jis tara ap na bataya ma na is tara keya
laken ma akar kesi be month ma P leko to sub months ma khud P lek jati hai
Ap Kuch mistake kr rahy Ho gy ap video me isi point ko gur se Dekho InshaAllah Ho Jay ga
Sir attendance sheet Jo aap ne banyi hai last me Sunday off likhe hai sir waha H likhne pe Sunday off dikha rha hai show nhi kar rha hai
hi can you please upload your sheet thank you so much
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
PLZ AGR KISI OR KO KUCH PTA HA TO MUJHA GUIDE KRDA
Bro data is not put in every month? same data is every month
and how to save every month data ?
how automatically P mention ho jae date wise if huge employees list ho
Asslamo alikum
Is men hme over time count krna hai wo kaise krenge
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
Bhai me ye bnaya tha lekin Jaise Maine January ka Banaya vah PDF Mein save Ho jaye Ab Mujhe February ka banana hai to Usi sheet me entry ho jaye
Isme selary seet kese add kare
Dusra month select krne par pahle month ki attendance show hori hai
Sur meri next sheet select ni ho ri h
great buttttttt work only for one month not for whole year same sheet.
Bhai mobile me Kiya ye ban sakta hai
G ap MS Excel Mobile me download kr k bana sakty ho but ye both difficult ho ga ap k liye. Is liye ap computer me batao
Mera comment parhen mjhy jwab den iska sir please
Sir how we calculate if there is Sunday overtime duty
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
ruclips.net/video/KC2rKmrw6OY/видео.html
Date k liye jo formula copy ke liye hai f4 ka keyboard se karne par nahi aa raha hai
=IF(01 select kiya
Formula =IF(select 01 date
Sir e sheet mughe chahiye
But Jo p l a value dete h Sam value all page pe show krta h
Sir ji is problem ka solution to dijiye
Please project file download link
Sir jab hum month change kar rhy h to Sunday py p q likha howa a rha h
Sunday Waly cell per ap conditional formatting use karain. Video me dekhy bataya geya ha
Jazakallah sir
How to type the not equal
download link please
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
Is template ko dijiye
Sir mere se start date ka formula hi ni lga sai terha nazer hi ni a raha
Koi reply ker de kese lagna hai formula
Please Salary sheet, extra time sheet no riport bando na
Salary sheet already banai ha ap is link per click kr k dekh sakty ho
ruclips.net/video/bqQhR4M-afk/видео.html
@@aaosikhain but apne Pf ka nhi likha na sir