Fully Automatic Attendance Sheet in Excel

[@Muhammad_Asif_1978]

Behtreen.. Excellent
Ap ne nahayat hi easy tariqy se samjhaya.Noce

[@amarvilljonathan4106]

Bahut jabardast sir..kya khub bataya hai aapne ❤

[@thepathtoallah9180]

Sir apki.vedios bht achi hti hain smhj aati hai

[@aaosikhain]

Thanks

[@thepathtoallah9180]

@@aaosikhain Sir.apsy contact krna hai

[@patankaraalekh]

Bahut aasan tarike se sikhaya haai .. bahut hi badhiya video

[@rahulkumar-uh2ge]

Isme month change krne par data apne aap kyu sab me vhi data aa rha hai....??????

[@vsvp33]

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

[@danishraza8153]

Same problem here

[@mohammadsarfraz2015]

Yes same problem here

[@SA_N_TU]

Same here

[@punnupantawane8176]

Tell solution

[@SushmaMaurya-h5x]

Same yrr

[@mazherabbassialvi8689]

Well Done I first Time Create Attendance Sheet , Your way of explaining Method is so Simple and Clear , I really Appropriate your my Dear

[@aaosikhain]

Thanks

[@pravatbiswas6715]

You are a great teacher sir.

[@aaosikhain]

Thanks

[@aatifahmed7794]

I have same query about entering data on on sheet is also displaying on another, kindly give solution

[@shubhammishra7198]

​@@aaosikhainkya thanks present,absent,leave all month same

[@miang7898]

Apki video sy mujhy excal sekhny ka shok peda ho gaya boht asan thanx

[@aaosikhain]

Thanks

[@RazaNaiyar]

@@aaosikhain AOA SIR CAN WE GET THIS TEMPLATE IN EXCEL PLEASE?

[@mohammedanies9762]

Nice if you share the Excel sheet link it is more helpful. Informative video shukran❤

[@shaanishfaq9103]

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 😢

[@Qasimawan]

sir if ky bad jo 2 value sath lgani hn beach m F4 lgana ha kia?????

[@vivekav3557]

Sir you are a great teacher can you please help me with adding to week offs to dis Excel like Saturday and Sunday both

[@ishtiaqkhan3181]

I have the same problem. Plz educate me if you know.

[@Onlinework182]

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

[@vloging-e9v]

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

[@MudasirAli-fs4yr]

Sir Attendance percentage kasy attached krain gay 12 month year by year ka sath ay ....

[@MudasirAli-fs4yr]

Automatically every month or every year Ka sath ati jay...... Please guide me😢

[@thepathtoallah9180]

Bht alwaa sir

[@mohammadsarfraz2015]

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

[@raismsw3969]

its a very easy I try it make my Labour salary records & then repeat comments

[@Rayumv]

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?

[@cyrincharley410]

Same

[@DevRaj-gm2tn]

Same problem😢😢😢

[@itxkhan-016]

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

[@srisaitejamallipeddi6074]

Same problem! Did you manage finding the solution for this please?

[@ShivamPandey-qj6vc]

Sir ek problem hai ham kis mahine pe jo attendance lagaa rahe hai oo sab pe aa raha hai

[@Mithu29175]

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

[@AbdulRehmanDhother-x8h]

Nice vedio Sir

[@sundarfactorystore]

Sir g es my overtime kissy add ho ga

[@saikiran7687]

This is awesome ❤

[@unique5858]

Aoa when I change month coumn values do not change it was entered for September but same values in columns shown in other months

[@k...kr1081]

Change 1 date format cell to Date format than it will change

[@ishtiaqkhan3181]

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.

[@ramanvarma8526]

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

[@SUNDEEPELECTRICAL]

sir isme attendance banaya lakin months chainge karejab attendance chainge nahe horaha hai same attendance rahera sab months me usko kaisa salve karna ?

[@rashmidwivedi9383]

Sir i am facing problem in employee name ke baad date nhi aa rahi if function lagane par

[@noobsgamers2430]

Bai jan is page ko 1 page par print kar skte hein

[@arshadshakir7679]

Excellent

[@rashmidwivedi9383]

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

[@ZabeehUllah-ii8jm]

Aslam u Alikum sir kia ya attendance sheet ko aik computer ma bna ka ksi or computer ma chala sakty ha pdf ka zaria.

[@rahmanali6507]

Elective subjects ka kis tarah banayengy plz guide me

[@DPSCHafizabad]

GREAT ! HOW WE SAVE EERY NONTH DATA FOR FUTURE USE

[@sanajan5534]

Excel kitne months me complete seekh jata hai .yani kitne months course krna parega

[@aaosikhain]

Depend on you

[@cutedogstube6184]

GREAT !!! WHERE CAN I DOWNLOAD THE TEMPLATE

[@shortsvideos7050]

Sir date value lane par sell me sidha error aa raha hai

[@sulliyamohammad7212]

Sir ji month change karne pe data change nhi hota same aaaya he uska koi upaye batao

[@unique5858]

Same query I have

[@azharyousaf5426]

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

[@24MovieMasala]

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.

[@BIRDSTORY-HINDI-URDU-ENGLISH]

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

[@NoorMuhammad-sq8xm]

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

[@bittu25]

Thanks

[@miang7898]

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

[@aaosikhain]

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

[@miang7898]

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

[@JaspalSingh-x3x]

Good information bro keep Carry on

[@kyfparacha]

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.🤔

[@TOXICGAMER-wp3zb]

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

[@TOXICGAMER-wp3zb]

PLZ AGR KISI OR KO KUCH PTA HA TO MUJHA GUIDE KRDA

[@naatersool7633]

Asslamo alikum
Is men hme over time count krna hai wo kaise krenge

[@ms.alimessages2959]

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

[@saimtechdc5109]

Bhai jawab nhi jabeedast it's very easy

[@UmarFarooq-vy7cv]

Mashallah That's Great. I love it because I have been searching such type of format to make an attendance sheet

[@mohammedmuzafar4291]

Bhai when we are updating in June attendance same thing is applying for next month also can you please help here

[@Mubashar_Ali_Sidhu]

Same problem absent , Leave All month same

[@Mubashar_Ali_Sidhu]

Please solution

[@স্বপ্নকুঁঠির-ম৬ঘ]

attendance make need sheet with time in and timeout and overtime and Late then you make Present and absence then you make monthly Salary.

[@rizingart]

Thank you Bro

[@alamzebkhan8328]

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

[@aaosikhain]

Thanks Bhai. InshaAllah next video me ap ko issue nahi ho ga

[@solimbinanas8717]

Great sir

[@aaosikhain]

Thanks Bhai

[@crezy_editings]

Isme selary seet kese add kare

[@ahsanrafi8126]

Good

[@alamzebkhan8328]

Badhiyan hai ji

[@aaosikhain]

Thanks Bhai

[@AvGupta-fv4hj]

Bahut sahi sir

[@SajjadAzmi-gf5gh]

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

[@srkrajput9805]

Dusra month select krne par pahle month ki attendance show hori hai

[@PoojaGautam-k7v]

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

[@powerview25]

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

[@aaosikhain]

Ap Kuch mistake kr rahy Ho gy ap video me isi point ko gur se Dekho InshaAllah Ho Jay ga

[@NishantKumar-hk5xc]

Sir pl help me to make attendance of 130 guards as rotation on 6 present 1 rest not weekly, pl help ke

[@dipankarpal5795]

Changing date and year does not change present absent

[@muhammedrazall]

Sir how to merge rows Sunday only

[@thepathtoallah9180]

Sir main jb data validation main jta hon r source py jany k bd sheet select nh ho rhi plz batin

[@rinrovin6054]

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.

[@satveersingh7435]

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

[@atiqrehman1223]

Excellent work

[@mudassirsaeed1723]

wow great 😎

[@aaosikhain]

Thanks 😊

[@muzammilqureshi1635]

how automatically P mention ho jae date wise if huge employees list ho

[@faizanakhtar2807]

hi can you please upload your sheet thank you so much

[@AvGupta-fv4hj]

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

[@muhammadhanan-l3p]

Bro data is not put in every month? same data is every month
and how to save every month data ?

[@RajaKhurram-i1j]

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

[@muhammadwaqas4699]

Awesome 🎉🎉🎉.

[@vivekav3557]

Sir how to add two week offs

[@rahulkumar-uh2ge]

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...

[@rahulkumar-uh2ge]

Koi reply aaya nhi Bhai apka

[@nimraali2608]

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

[@Naseerahmad327]

Sur meri next sheet select ni ho ri h

[@GauravKumar-vk9gl]

Date k liye jo formula copy ke liye hai f4 ka keyboard se karne par nahi aa raha hai
=IF(01 select kiya

[@GauravKumar-vk9gl]

Formula =IF(select 01 date

[@nadapmia3112]

Bhai mobile me Kiya ye ban sakta hai

[@aaosikhain]

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

[@vidyadhares7844]

Sir how we calculate if there is Sunday overtime duty

[@aaosikhain]

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

[@nimraali2608]

Mera comment parhen mjhy jwab den iska sir please

[@satveersingh7435]

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

[@Adeel_Aman1780]

Sir mere se start date ka formula hi ni lga sai terha nazer hi ni a raha

[@Adeel_Aman1780]

Koi reply ker de kese lagna hai formula

[@mohammadsarfraz2015]

Sir ji is problem ka solution to dijiye

[@kiranwahid4955]

Sir jab hum month change kar rhy h to Sunday py p q likha howa a rha h

[@aaosikhain]

Sunday Waly cell per ap conditional formatting use karain. Video me dekhy bataya geya ha

[@kiranwahid4955]

Jazakallah sir

[@Suryak7662]

But Jo p l a value dete h Sam value all page pe show krta h

[@UsmanKhan-lk7uv]

great buttttttt work only for one month not for whole year same sheet.

[@Nk-interior-]

Sir e sheet mughe chahiye

[@saintsoomro]

Awesome 👍 sir

[@Maniskavlog]

sir Nepali date ke liye kya karna hoga start date end date ke liye please

[@aaosikhain]

Sorry bhai, Nepali date Kia hoti ha mujy ilam nahi. But me study kr k batao ga

[@Maniskavlog]

@@aaosikhain ok please try kijiyega 🙏🙏

[@srinathm756]

How to type the not equal

[@mdjakirhossen4576]

Please project file download link please

[@suparsbanthia4805]

Usefull❤

[@nadapmia3112]

Is template ko dijiye