Jab 2nd month ka open Karte hai tuo same data show hota hai sheet change nahi hoti, mene iss formula se inventory ka sheet banaya, not work jab month change Karte hai tuo column mai data remain rehta hai.
sir isme attendance banaya lakin months chainge karejab attendance chainge nahe horaha hai same attendance rahera sab months me usko kaisa salve karna ?
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 😢
Isme jo data fill kr rahe hain har month me vhi same data apne aap fill ho rha hai... Agle month me sheet khali honi chahiye... Jab month change kr rahe hain...date me uski cell khali honi chahiye...
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
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
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 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
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
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.
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
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.
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
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
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.
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
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
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 th-cam.com/video/KC2rKmrw6OY/w-d-xo.html
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
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
Behtreen.. Excellent
Ap ne nahayat hi easy tariqy se samjhaya.Noce
Jab 2nd month ka open Karte hai tuo same data show hota hai sheet change nahi hoti, mene iss formula se inventory ka sheet banaya, not work jab month change Karte hai tuo column mai data remain rehta hai.
Bahut jabardast sir..kya khub bataya hai aapne ❤
Iss condition ke ak sath sir absent, nikale to sir Sunday wala din bhi count kar lete hei ,,,, plz 🙏 batao na sir
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
sir if ky bad jo 2 value sath lgani hn beach m F4 lgana ha kia?????
Sir apki.vedios bht achi hti hain smhj aati hai
Thanks
@@aaosikhain Sir.apsy contact krna hai
Bahut aasan tarike se sikhaya haai .. bahut hi badhiya video
Isme month change krne par data apne aap kyu sab me vhi data aa rha hai....??????
How to change data when we change date and year
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
Start date me value aa raha hai kya kare
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
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
Sir i am facing problem in employee name ke baad date nhi aa rahi if function lagane par
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 isme attendance banaya lakin months chainge karejab attendance chainge nahe horaha hai same attendance rahera sab months me usko kaisa salve karna ?
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 😢
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
Sir date value lane par sell me sidha error aa raha hai
This is awesome ❤
Isme jo data fill kr rahe hain har month me vhi same data apne aap fill ho rha hai... Agle month me sheet khali honi chahiye... Jab month change kr rahe hain...date me uski cell khali honi chahiye...
Koi reply aaya nhi Bhai apka
Sir ek problem hai ham kis mahine pe jo attendance lagaa rahe hai oo sab pe aa raha hai
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😢
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
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
Mashallah That's Great. I love it because I have been searching such type of format to make an attendance sheet
Sir g es my overtime kissy add ho ga
Nice if you share the Excel sheet link it is more helpful. Informative video shukran❤
Awesome 🎉🎉🎉.
Bht alwaa 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
PLZ AGR KISI OR KO KUCH PTA HA TO MUJHA GUIDE KRDA
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
Nice vedio Sir
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?
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 pl help me to make attendance of 130 guards as rotation on 6 present 1 rest not weekly, pl help ke
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
Good information bro keep Carry on
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.
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
Changing date and year does not change present absent
Excellent work
Sir main jb data validation main jta hon r source py jany k bd sheet select nh ho rhi plz batin
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
Excellent
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.
Aslam u Alikum sir kia ya attendance sheet ko aik computer ma bna ka ksi or computer ma chala sakty ha pdf ka zaria.
its a very easy I try it make my Labour salary records & then repeat comments
how automatically P mention ho jae date wise if huge employees list ho
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?
Sir how to merge rows Sunday only
Isme selary seet kese add kare
Sir how to add two week offs
GREAT ! HOW WE SAVE EERY NONTH DATA FOR FUTURE USE
Bai jan is page ko 1 page par print kar skte hein
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.
Dusra month select krne par pahle month ki attendance show hori hai
Asslamo alikum
Is men hme over time count krna hai wo kaise krenge
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
Elective subjects ka kis tarah banayengy plz guide me
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
Thank you Bro
Sir ji month change karne pe data change nhi hota same aaaya he uska koi upaye batao
Same query I have
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
Great sir
Thanks Bhai
Bhai jawab nhi jabeedast it's very easy
wow great 😎
Thanks 😊
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
Bro data is not put in every month? same data is every month
and how to save every month data ?
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
GREAT !!! WHERE CAN I DOWNLOAD THE TEMPLATE
Sur meri next sheet select ni ho ri h
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 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
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
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.
But Jo p l a value dete h Sam value all page pe show krta h
Badhiyan hai ji
Thanks Bhai
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
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
Bahut sahi sir
Good
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
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 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
th-cam.com/video/KC2rKmrw6OY/w-d-xo.html
Thanks
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
th-cam.com/video/GJEOiAnwv2U/w-d-xo.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
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
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
hi can you please upload your sheet thank you so much
Sir ji is problem ka solution to dijiye
How to type the not equal
Awesome 👍 sir
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
great buttttttt work only for one month not for whole year same sheet.
Sir e sheet mughe chahiye
Mera comment parhen mjhy jwab den iska sir please
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
Please project file download link please