Fully Automated Attendance Sheet in Excel | Attendance Sheet in Excel

[@jayaweb_majedmoshati]

You are the first teacher
I thank you

[@PowerExbyJitendra]

Thanks a lot

[@logisvaarichandra4919]

tq sir im new in excel, will slowly learn more, Once again tq sir

[@PowerExbyJitendra]

Best wishes for you

[@jobdethperalta]

@@PowerExbyJitendra if i change month the Present place not changing

[@thekalyanclips]

​@@PowerExbyJitendramonth is not changing by changing month solve this problem

[@jayaweb_majedmoshati]

At 15 minutes and 31 seconds, the whole thing was incomprehensible

[@MyChanel93]

Very useful TQ so much bhaya

[@PowerExbyJitendra]

Thanks

[@shahqasim8513]

You are great and best teacher , and you also have good method of teaching , Thanks 🌺

[@PowerExbyJitendra]

Thank you so much

[@Bhujkaraoke]

Very Great, kya old data save hoga ?

[@MarlonPepaño-b7u]

thanks for this great tutorial.

[@PowerExbyJitendra]

You are welcome

[@PowerExbyJitendra]

Esa bilkul bhi nahi hai

[@roshanchaurasia1899]

Excellent

[@PowerExbyJitendra]

Thanks

[@SubodhKumar-fb4nh]

Great Thanks

[@PowerExbyJitendra]

Thanks

[@rohitshooter1005]

Wow sir tq❤🎉🎉🎉🎉

[@PowerExbyJitendra]

Welcome

[@maria_condensada]

Very nice, i have a question. What if I will have the month, day and weekdays. How to do that? thank you

[@waqasikhlaq7424]

i love your Channel, can u please teach how to make a Roster ?

[@PowerExbyJitendra]

@@waqasikhlaq7424 ok

[@ElSafoua]

Thanks

[@PowerExbyJitendra]

Welcome

[@kamrulislam3238]

Holiday two days (Friday, Saturday) rules to highlight together?

[@manishchaudhary9110]

Rounded rectangle shape me kisi ek date ke present aur absent aa sakte hai kya?

[@rajeshoraon7635]

How to fix data means present and absent with month wise when change the month data will also change month wise

[@nikhilsoman674]

Very useful. But how to save month wise data

[@mallikarjunkhanapure5212]

Thank you sir, class is very nice and easy to learn difficult topic's and which Book you referring this Advance Excel, please inform us sir

[@PowerExbyJitendra]

Thanks a lot

[@Bharath-j1d]

When changed month present and absent also entering same as previous month how to solve

[@Vivek-yd6yk]

Sir month change kiya to har sheet me Same Data dikata hai blank nahi hota ?

[@PowerExbyJitendra]

Attendance vala data delete kar lijiye

[@Vivek-yd6yk]

@@PowerExbyJitendra attendance ka Data delete kiya to har ek month ka Data delete hota hai

[@PowerExbyJitendra]

@@Vivek-yd6yk it means apne sabhi sheets ko select kiya hua hai. Please select only only one sheet from which you want to delete data

[@resin_studio]

How to edit the week off column want to remove the error today is weekly off

[@Kishankumar-ok7ic]

Sir will u help me creating rate list which can update with color coding (rate up n down)

[@PowerExbyJitendra]

@@Kishankumar-ok7ic yes you can use conditional formatting

[@adnankondkar9642]

Sir. Is format me agar number of employees zada karna ho tho kaise kare please reply

[@dharmenkumar1401]

jb main date main days draag kar rha hu to 17 ke baad sidhe 20 q aa rhi hi 18 19 mnissing hai ??

[@nitishtechnical3673]

sir sheet download nhi ho raha hai sir

[@ms.alimessages2959]

Hello brother thank you brother I need start from 16 to15 type attendance can you help me no problem Hindi

[@ramanvarma8526]

Sir ek problem hai attendance fill karte hai to all month me same entry hoti hai why

[@zissu.1]

Same Problem

[@modiabhinav1]

same

[@Ahmadali-zk1bh]

Same

[@rajeevr9441]

Same

[@safikue]

Sir. I want weekly day off base on I'd no. Could you please help that if I enter any employees id no. It should be feel automatic. Like employe I'd no 101.his day off. Monday. Then. Then should automatic fill. Please help

[@vishalagrawal8717]

Sir can please make a video on how to covert numbers to words? I used vba code for this but even after saving it in macro enabled excel it doesn't work after reopening the workbook

[@PowerExbyJitendra]

VBA file should be save as Excel Macro Enabled Workbook'
Then will work continously

[@bhushanjaju]

Whether every month data is saved ?

[@PowerExbyJitendra]

Create a copy for next month

[@Vicky-tn7sl]

Week off function not working and showing message You cannot use referencees to other worksheet or workbook for conditional formatting criteria

[@aniketbonatemusic87]

What if employee Holiday me working hai??
Aur Overtime ka bhi format add kare isme.

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

[@nixblossom5696]

Sir, Quesion 1- If i want to add 2 week offs ,like saturday & sunday?.....

[@PowerExbyJitendra]

You can use same technique. One more combo box will be inserted.

[@gajendrarawat2258]

Sir if we are changing month in January sheet than automatically changing month in all sheets

[@tanmoydas4834]

Yes

[@PradumnYou]

Sir Google sheet me work krega

[@manishchaudhary9110]

How to see how many employees present on a particular date

[@shekharbisht2080]

Sir ji Esme month change krne pr new present or absent nhi aa rha h kya kru

[@Snmahaur]

Sir, isme 1 day ki jagah half day 0.5 value add nahi ho rahi hai.

[@neharajput568]

Sir mere insert ke rounded rectangle pr formula aaply ni hora

[@manishchaudhary9110]

Sir ye to sabhi months ka same hi aa raha hai

[@PowerExbyJitendra]

@@manishchaudhary9110 please create a copy for new month

[@patelpankajhiralal9547]

Sir
Your work is Good But it is not Fully Automatic because we have to manually fill P or L

[@rjacreation9165]

sir mujhe attendance me konsi konsi date me present or absent he bo kese niklu please help

[@dancefactory7606]

Sir kay me is Excel mein aad karke reedting karsata hu

[@Resh837]

Sir how to calculate leave/hr instead of half day

[@aseersolkar]

Agar National Holiday ho to ?

[@PowerExbyJitendra]

You can add one more combo box for holiday

[@shemeerarazak6680]

why in my excel error alert not working for sunday

[@PowerExbyJitendra]

Please apply data validation coccectly

[@manoranjanTiwari94]

P or ot me chahiye

[@HaftayGebrehiwet-e9l]

this formula does not work in my pc,why?

[@vikasmishra3194]

Har month ka data save kaise karen

[@rohitparihaar4367]

Sir Ya Format Contral Ka option kassa att hn Contral ku ka mara Excel ma to nhi aai rha hn

[@PowerExbyJitendra]

Select combo box and right click

[@mathewmchacko9400]

well but how to holidays high light in excel pls add

[@PowerExbyJitendra]

Ok

[@CrazyLife-Rishabh]

If any employee is resigned than previously monthly data aslo deleted please solution dene

[@PowerExbyJitendra]

No need to delete previous month sheet you have to create a copy of this sheet

[@CrazyLife-Rishabh]

Sir please send your mail id I can tell talk to you or any mobile number contact with you

[@SArobi-ue1bm]

Amr off day gula highlight hossey na kno?... Formula disse tar por o hossey na...ata kno hossey...?

[@babbudhillon5370]

month change kare to attendance wo hi rehi tii hai

[@thekalyanclips]

Nobody can solve this problem I want also solution

[@SKumarOfficial_]

Month change karne par attendance change nahin hota hai. Same attendance rahta hai. Kyu?

[@PowerExbyJitendra]

Clear your attendance first

[@SKumarOfficial_]

@@PowerExbyJitendra lekin phir pichle month me Jane par current month ka attendance AA jata hai. Koi upay kijiye sir 🙏

[@PowerExbyJitendra]

Sahi tarika hai ki aap is sheet ka ek aur copy create kar lo to ye bhi safe rahegi

[@SKumarOfficial_]

@@PowerExbyJitendra matlab har ek month ka alag alag copy save kar len?

[@Waseem.916]

Then Wt is the need to make drop down list of months

[@kabushkids6749]

HOW TO SAVE THE DATA BEFORE MOVING INTO NEXT MONTH

[@PowerExbyJitendra]

Creat a one more copy of this sheet. Right click on sheet name and creat a copy

[@kabushkids6749]

THANK YOU FOR THE INFORMATION IT WAS REALLY HELPFUL
@@PowerExbyJitendra

[@RKhdMedia]

please Download link

[@PowerExbyJitendra]

Link is in description

[@RKhdMedia]

@@PowerExbyJitendra Link is not work, Download option not showing

[@RKhdMedia]

@@PowerExbyJitendra please good drive link

[@ShahidulIslam-hk6fm]

স্যার,
এই সিট পূরণ করে যদি মাস পরিবর্তন করা হবে তাহলে ঐ একই পূরণ করা তথ্য থাকে, মাস অনুযায়ী সেভ করার কোন উপায় আছে নাকি, একটা মাসের তথ্য পূরণ করার পর যদি অন্য মাস সিলেক্ট করি তাহলে নতুন করে হবে, আগের মাসের টা চলে আসে। এটার কোন সমাধান আছে নাকি। প্রত্যেক মাসে তথ্য প্রত্যেক মাসে আলাদা আলাদা থাকবে এবং যখন যে মাস সিলেক্ট করবো তখন শুধু সেই মাসের তথ্যই দেখাবে, এমন ভাবে কি করার কোন উপায় আছে। থাকলে একটু জানাবেন প্লিজ।

[@nagendrasharma5411]

YHA BHI WAHI SAME ISSUE SAME DATA IN EVERY MONTH

[@rajeevr9441]

Never follow this video it’s having the same entry’s on every month he is not replaying also how to rectify it

[@PowerExbyJitendra]

@@rajeevr9441hello I have already cleared that if you want to create it for new month please create a copy of this sheet.

[@musondapeter3441]

WhatsApp line please

[@avfulltimemasti1944]

कुछ ऑप्शन को आप छुपा रहे हैं आप नहीं बताना चाहते

[@PowerExbyJitendra]

ऐसा बिल्कुल नहीं है

[@nitishtechnical3673]

Please sir apna whatsapp number dijiye n