Just like attendance sheet, you can create Leave Tracker too. Don't put P (Present) in that sheet. Just put name of all the leaves, absent, holidays and your format will be ready
THNK YOU SIR, Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you ❤❤
Es sheet me agar hum date 2 ke uper coulam me countif ka formula lagate hai aur usme p or A ka total alag alag karte hai fir date me filter lagate hai aur 2 tarikh me helper select karte hai toh P ya A ka count kaise change hoga jaisa ki subtotal me filter use karne me figer change hoti hai
Insert extra column in the end for half day for HD and in the main seet, type HD apart from P and A. It will take Half day too. Don't forget to use countif to count half days
Sir Very well explained you are very very good. . My one question is that After the end of 2024 25 years, will it be automatic for the next year or will I have to change the face again Kindly, if you tell me a little, I will be very helpful.
12 month ki attendance 1 sheet me ho skti h kya month change Kiya jese Jan month ki attendance finish ho gyi to Feb select kar liya Feb ke liye attendance chalu ho skti h kya alag month ke liye new workbook na lena pade
Everyday overtime agar lagega to uska calculation is sheet par kaise hoga??? Or ek coloumn salary per person or hoursly income of single.person bhi hona chahiye...
Agar hamay sheet change nah Karni usi sheet Mai List Say Next Month Select karay to Jo P,A Waly Column Hai Woh Blank Hojaye Har month usi tarha say woh kaisay karay
Sir isme 1 problem hai jaise aapne data fill kar diya or fir feb month select kiya to usme 30 or 31 ka data bhi show ho raha tha. Usko bhi gayab hona chhiye tha. Or last main days calculation bhi galat aa raha hai
Check out the courses
pwskills.com/courses/?category=6571665650c2447cf47803aa&
Per main kanpur she ap kanpur institute h.apka sent no sir ji😊
Shift ke st fress Karo Fast letter capital ho Jayega
Sir kisi bhi month ka date kisi dusare month ka date ka attendance sheet automatic kaise banaye example
Start date 21july se 21 agust end
ہم آپ کے شکریہ کیسا ادا کریں
آپ نے تو ہمارے زندگی بدل دی ❤ سلام ہے اپکو
Sir aap ki iss videos me time laga but last me Masic hua hai...very good information.sir..ji❤❤❤❤
We learning simply & easy way,Thanks sir for giving information on UA-cam.
🙌Best teacher for advance excel
You guys are really smart and expert. Thanks sir❤❤
Sir G you Have Great Skills of teaching your Absolutely mind blowing Lub u From KSA🇸🇦
I have learned lots of knowledge from u
Good job sir ...CAN YOU EXPLAIN FORMULAS WITH BASIC BODMAS & SYMBOLS ( HOW TO USE THEM ).
YOUR WAY OF TEACHING IS ✨✨✨✨✨✨✨
Video informative h , lekin sab khichdi ker Diya h...........
Right
😂😂😂😂
Jo samjhega nahi usko to khichdi hi lagega
Thank you so much. Create karna padega baithkar pc par.
Excellent teaching methods 👌👌👌
Sir ji jish ko aap ki videos pasand hai thik agar kishi ko pasand nhi hai to bhi thik aap iss tarh ki or bhi videos aapload karo...thanx❤❤❤❤
Bhut ache se samjhaya gurudev
Sir you are Great..!!❤
Amazing and informative video, sir😍
Wonderfull ....apki hi vedio samajh mai aati hai bas..you tube par
First comment ❤ love from odisha
I also from odisha
Jay Jagannath
May i know you district please
@@GanapatiKhara-c7f
Kendrapara, odisha
Koraput
Thanks a lot sir
Salute sir ache se samajh as gaya❤❤❤
Nice & very helpful video thnku sir❤
Very useful, thanks
Thanks you sir bahut ache se samjhaya aap ne
half day ka adha present day main or adha absent main kaise ayega
Bhaiya mai apki video se boht kuch shikh paya thank you bhaiya❤️🫡🫡🫡🫡
Hello sir I request you please make a video on leave record..like if automatic monthly leave add and less please
Just like attendance sheet, you can create Leave Tracker too. Don't put P (Present) in that sheet. Just put name of all the leaves, absent, holidays and your format will be ready
Excellent video, thank you so much sir 🙏
Thank you so much sir 🙏🙏
THNK YOU SIR, Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you ❤❤
Nice sir bahot achhe se samajh mai a gya
Very nice class
Thank you sir
Thank you sir...fir se automated attendance sheet upload kiye....😊
❤❤❤❤❤❤❤❤❤❤❤❤ something different for others UA-cam channels in Excel
Helpful information 👍👌
Thank you sir ji aapki vidio bahut hi helpfull rahi
Very nyc sir ❤
Well-done sir informative ha
Great sir
Ap ka samjhanay ka undaz acha hai
Nice work and Info Sir
Thanks
Your videos are great but you should upload data set for practice
HANJI BHAIYA BHT ACHE SE SMJH AYA THANKYOU
Syd yhi mi dhund rha tha bhot dino se❤
Thank you
Es sheet me agar hum date 2 ke uper coulam me countif ka formula lagate hai aur usme p or A ka total alag alag karte hai fir date me filter lagate hai aur 2 tarikh me helper select karte hai toh P ya A ka count kaise change hoga jaisa ki subtotal me filter use karne me figer change hoti hai
Thank you so much brother for this👍🙂
Good guide bro
Great majaa aa gaya❤
Good explanation i hope you achieve more success ahead ❤❤
Thanks sure helped a lot
Radhey Radhey bhai aur dhanyawad ❤
Very nice and helpful vedio
Nice video brother god bless you
Perfect. Thanks for sharing
Half day present ?
Insert extra column in the end for half day for HD and in the main seet, type HD apart from P and A. It will take Half day too. Don't forget to use countif to count half days
Great sir thank you very much
Thank you sir bahut achche se samajh aa gaya ❤❤
Bhut nice sir 😊😍💖🤗
Thank You So muchBrother 🙏🙏😊😊
Super se bhi upar
Love you sir 😘😘😘
Very nice explanation
Kya sir aap loan ke bare m puri knowledge de sakte h kya
Ok bro very nice video ❤❤❤❤❤❤
Very nice 🎉video g god bless you sir
Sir Very well explained you are very very good.
. My one question is that After the end of 2024 25 years, will it be automatic for the next year or will I have to change the face again Kindly, if you tell me a little, I will be very helpful.
Keep a blank sheet and you can use it for 2025 also. Just change the year and it will be ready to use
Nice explanation 👍
Very informative videos
Bhaiya ek baar ho ske toh salary sheet ka video b bna dijiye simple aise hi....DA, HRA , simple basic croos salary ka
Bohot acha video tha very help full.....😊
Thank you very much
Thank you sir❤
Very informative video ..
What is wrape formula
HowTwo files compare and find error cells
Awesome video 🎉
Hello sir please create a complete course of excel
Amazing sir. Thank you
Thanku soo much sir.
Iiaqat from Pakistan. Amzing hi
amazing explanation
Sir agar month 31 ka hai tab to thik hai agar 28,29,30 ka ho to bhi count 31 ka hi ho raha hai
Absent and. Present 31 ke hisab se ho ra hai
Thank you so much ❤❤❤❤😘😘😘
Awesome sir great
12 month ki attendance 1 sheet me ho skti h kya month change Kiya jese Jan month ki attendance finish ho gyi to Feb select kar liya Feb ke liye attendance chalu ho skti h kya alag month ke liye new workbook na lena pade
Super Bhai ❤❤
Very informative video also very helpful sir ap se personal course kr skty excel m?
At 10:12 kya select krna Ctrl + ?
agr attendance sheet m time in & time out and overtime bhi mention krna h toh kaise krege please ye wali video bnaoge
Mast bhai very very good
स्कूल के रजिस्टर मे जो अटेंडेंस का भी वीडियो बनाईयेगा
Attendance name se sheet hogi vo open kar lo vo best rahegi
@@hariprakashlodhi755 सर कहा पर हैँ थोड़ा हिंट दे 🙏🏻🙏🏻
docs.google.com/spreadsheets/d/1xVc6H4YJTisceezo080X8JaJXjdbg3as1dSKoFzi0VM/edit?usp=drivesdk
Everyday overtime agar lagega to uska calculation is sheet par kaise hoga??? Or ek coloumn salary per person or hoursly income of single.person bhi hona chahiye...
Excellent 👌👍
very much thanks Sir so much thank.
Very good sir
Agar hamay sheet change nah Karni usi sheet Mai List Say Next Month Select karay to Jo P,A Waly Column Hai Woh Blank Hojaye Har month usi tarha say woh kaisay karay
Thank you sir 🥰🥰🥰🥰🥰
Here data is not changing with month change. When I change the month, the data will change automatically.
You can provide such videos.
Thank you❤
Nice video sir 💯😁
Informative video
Sir isme 1 problem hai jaise aapne data fill kar diya or fir feb month select kiya to usme 30 or 31 ka data bhi show ho raha tha. Usko bhi gayab hona chhiye tha. Or last main days calculation bhi galat aa raha hai
COUNTIF DON'T PICK PP WHY ?