Employee Attendance Tracker in Excel | Attendance Sheet in Excel

[@morelearnmore]

Very interesting video I am also learned from your channel a lot of work thanks

[@PowerExbyJitendra]

Thanks a lot

[@balajic8956]

Thanks for sharing and teaching excel tips.. Its very useful for me and I am adopting this table for my Dairy Farm.. Request you to make an excel which is applicable for Dairy Farm Management if possible..

[@PowerExbyJitendra]

Thanks🙏

[@nhoemchandy2511]

Sr can you make list How to enter the year to issue 12 months ? Thank you for sharing

[@nirupamabai9510]

Thank you so much for this explanation

[@PowerExbyJitendra]

Thanks a lot

[@shuklamondal1431]

Bhai glitch hy tumhare sheet me..months change karte hy to data nehi badalta hy aur delete kar do toh sab data delete ho jata hy!!

[@firojex.ibra786]

Same problem with me

[@AFPTCentral]

Fir Iskandar Kyada mtlb hua jb data change hi nhi ho rha h

[@quotal9357]

हाँ जी मेरे साथ भी ऐसा ही हो रहा है। यदि आपको इसकी जानकारी मिलती है तो प्लीज मुझे भी बताना 🙏🏻

[@gopaldass632]

Same problem

[@pratyooshsingh8769]

@@Office-Monk For 5 years how many sheets will be there. Har mahine ka tho alag alag sheet mein bhi ban jaayega.

[@gayatricomputerjetpur5442]

Sabse sandar videos All Excel video sabse advance

[@PowerExbyJitendra]

Thanks a lot

[@ashwinkathare840]

Very nice n easy 🙏

[@PowerExbyJitendra]

Thanks

[@PoojaGupta-ze6ke]

Thankuu so much bro

[@rajanprajapati8161]

Thank you very much 🙏

[@PowerExbyJitendra]

Welcome ji

[@MuhammadTariq-wj1wm]

Thanks for this video, let me know about conditional formatting rule in which you marked as Sunday in color. However, when I am doing change month by data validation so Sunday is not showing in colors

[@Stock_Analyst_Top]

Sir can you make video on these topics ? topic 1 : Day Wise Automated School Teacher Time Table Using Excel Sheet , topic 2: Automated School Teacher Time Table Using Excel Sheet. Special instruction : For a particular subject multiple teacher is available , class duration is 40 mins before break and class duration is 30 mins after break, every class has multiple sections. Saturday school timing is half. There are videos on these topics on youtube but your teaching skill is exceptional. That's why I am requsting. Thank you in Advance

[@ManojGupta-nl8fj]

Very nice sir, Thanks❤ Sir, yadi month me aane Wale any avkash ke dino ko is prakar se lock Kiya Jaa sakta ho to use bhi batane ka kasht kare. School me students ki attendance ke liye upyogi hoga.

[@arghyarana5869]

Hi Jitendra Ji, Thanks for sharing this. But while modifying one month's attendance (P/A) data, another month's data is automatically getting changed or modified. How to fix this? Please guide

[@Daanyaal007]

Any fix? Having same issue

[@hasnain7704]

I face some issue i change the month but P And A also stuck not previous Attendace showing

[@karanpadalkar007]

nice video sir

[@PowerExbyJitendra]

Thanks a lot

[@subratamishra2263]

What is the problem with attendance in this format? When I am giving January attendance, February attendance is being copied

[@thenailgal]

Did you find out how to fix it? I’m having the same issue, I need help fixing it.

[@BadrSaeed-c2z]

can you clarify how to make the values entered disappear after changing the month?

[@amittembhre4351]

you are right

[@vijayjs3655]

Hello sir thank you for your valuable information Agar koi employee name delete karo jaise vo kam chor diya to sare months m delete ho ja raha h kaise sare month se delet na ho bataiye

[@pratyooshsingh8769]

When i change the month even Mon Tue shows as holiday!! Please helo us rectify

[@shankhaccount]

Grate sir thank you so much

[@mdsulemanrehman2143]

Kya thanks agar app next month karte hain to pechle month ka show ho raha hai Esko karke kya faida west hai...

[@mohammedarhaan9694]

Can you please teach In case later if we want to add name's of the student in the leave tracker who will join newly.

[@johnson996633]

Once we change the month data is available for previous month. Kindly check

[@johnson996633]

Brother your sheet has glitch

[@Office-Monk]

Jitendra, Couple of things you can add to make this format really powerful. 1) Add Holidays on top of Days. 2) For weekoffs, provide the option. Provide 2 cells for Weekoffs and people can select weekoffs from the dropdown. Whatever days they will select, those specific days will be highlighted. 3) Also highlighted the columns from 1st employee to the last employee for Holidays For 2nd date, eomonth can be used to avoid the criteria of iferror. I watch almost all your videos. Nice teaching style. Keep up the great work

[@PowerExbyJitendra]

Hello dear thanks for your lovely comment. 🙏🙏🙏

[@Meriapeksha]

Bhai ek daily deposit lene wali sheet banao 5 year ki

[@PowerExbyJitendra]

Ok I try

[@kunalagarwal3735]

When I am changing the month or year the Present Absent Data is not changing, Why is this happening?

[@kunalagarwal3735]

Please help

[@thenailgal]

@@kunalagarwal3735have you received a response? I’m having the same issue

[@interiorlane1436]

Mere me week name wala formula nahi laga raha hai kaise kare

[@vishalsutar3973]

We usually need daily dashboard for attendance. How can we generate that since date is always changing .

[@OmarFaruk-fm2kj]

Daily & monthly production report for garments

[@AmarjeetKumar-dp2gl]

If formula lagane ke liye alt F4 prees karna hai ya ctrl F4 ya F4 plese help me sir

[@opgamerhacker2780]

Sir mujhe ek stock kai liye prog chahiye latest wala jis mai sale purchases ho aur edit ho air stock bhi batayen plz sir

[@muhammadmumtaz2270]

next month ki selection ky bad sheet blank nhi hoti is ka kuch bta din

[@sherazahmed5533]

agree sir all of the tutorials have same issue i have been through multiple videos

[@ManpreetSaini-qq6ev]

Same issue

[@rajanthakur7786]

THANKS

[@PowerExbyJitendra]

Welcome

[@pulakraj7]

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❤

[@BinzimbaTamang]

If we want to make from 20 to 20 than sir

[@morelearnmore]

sir employees ke TA/DA lekey ek video banahe jin men all employees record manage in a sheet details are >>> 1. Departure place, 2, date aor date ky below time, 3. Arrival place, 4. date and below time, 5. purpose of jurney, 6. KM, 7. rate, 8. day, 9. daily, 10. amount, 11 total amount. for 15 days. TA/DA with vloookup formula style. because i will every month make one by one employee. it is very hard work, so please make a video use these step in one sheet.

[@shwetarjha60]

Pls sir help attendance sheet m attendance change nhi ho rha h sirf month date he chnge ho rha btao muje kese kru

[@SalmanShaikh-qw3sc]

Plz isme video banaye to accha hoga alternate sat or Sun Aisa banaye k 1,3 or 2,4 pr ban jaye bcoz mene sheet aap ki video dekh k banaye hai sirf sat or Sun pr problem hu rahi hai

[@vilashrathore2951]

2007 wale varsion me nahi aa raha hai

[@sumejahan1327]

Dear sir, How to use present sbsent dropdown list in attendance sheet without Sunday. I want dropdown not showing in Sunday. Sir please tell me how can I do this. Dear sir I'm longtime flowing you from Bangladesh.

[@shafaatrameez6953]

Sir mujhe 15 to 15 attendance send karni hoti hai please us ka liye attendance sheet ka bataen or sath me current day highlight ho

[@Jayhanuman-t1p]

Sirji pp entry karana hai to kaise formula hoga

[@Rameshkodli-c4w]

Sir what is pully fix

[@PowerExbyJitendra]

Fully Fixed Means absolute range

[@AmarjeetKumar-dp2gl]

Cell refrence ke liye f4 se nhi ho rha hai sir

[@PowerExbyJitendra]

Please activate function keys in your system or you can use F4 key with FN key

[@interiorlane1436]

Baki sab formula lag Gaya

[@ashifkamal3516]

Per employees individual weekly day off and off employees different days count of P & A days, please solve the problem sir

[@aryankkgaming3038]

sir ji aap purush nahi maha purush hai. Charan kaha hai aap ke ? main aap ke charan sparsh karna chahta hoon sir ji 🙏

[@PowerExbyJitendra]

Ye to apka badappan hai vaise mai bahut hi samanya insaan hu

[@user-xh4od2ht8k]

👟 karloo

[@Drafting-d1z]

how to mention Holiday?

[@sayadakhatoonirfanansari5484]

SIR I WANT TO KNOW HOW TO ADD HALF DAY?

[@Live-gz6sp]

DAY CHANGE NAHI HO RAHE HAI.. BAKI SAB FUNCTION HO RAHA HAI..

[@Abhinav_V]

New employees aad krenge to ho jayega

[@Noorkhan006]

Sir ek chez ap NY nhi batai har month Ka data save kesy Hoga Banaya but har month me wahi data same araha he manually remove kr Raha ho me plz give me solution.

[@sanimunir]

If two days are off i e Saturday and Sunday, then sir, what should be formula in data validation bar???

[@avishekdas2727]

Please apple "or" formula

[@Navshaktidance]

WHAT IS THE USE WHEN WE CANT IMPLEMENT IT DUE TO THE GLITCH IN THIS SHEET. GLITCH IS: on changing the month, present and absent that was feeded doesn't change for different months. data feeded for some particular month is getting copied for all other months. and if we delete the data from a month then it gets deleted from all other months also. It was really a nice effort but whats the use if we cant use it. I saw so many comments highlighting this glitch, but bro u haven't fix it yet. Kindly do it so that yr effort gets appreciated. Thanks by the way.

[@PowerExbyJitendra]

You can create a copy for next month by using the option of move and copy

[@Vineetpp]

Sir isme isu ho raha h

[@memersanju6654]

Ek question tha For ex_Jab v hum kisi ek particular Month select krte hai, aur attendance sheet Wale cell mai kuch v data type krte hai, Toh wahi same data har month k sheet mai show ho Raha hai, Hum chahte hai ki woh data sirf ek hi particular Month k sheet mai show ho, na ki har month k sheet mai,

[@adonaishut1670]

But sir when we change month data is not changed

[@PowerExbyJitendra]

Because data is filled manually

[@adonaishut1670]

How to link with raw data

[@jogarupadhall9882]

@@PowerExbyJitendra Sir, when I change for the next month ,the data is automatically filled there from the previous month and if I am removing that, the previous month's data is also getting deleted.Can you please guide how to fix the problem..?

[@TangyMelody]

Dekho Jan 2024 h uss ko next cell m eomonth fun dalo it will work just ek cell jump kar k uss re m try karo

[@memersanju6654]

Sir ji Mera DateValue ka function #VALUE return kra rha hai. Iss bare mai kuch bataiye

[@umeshkumarrajput6640]

Sir ab aap ye bataye hume agar hum is sheet me month change kare to absent aur present fill kiya hai woh show nahi hona chahiye jis month ka data humne fill kiya hai kewal us month ka data show hona chahiye agar aisa hota hai to hum ek hi sheet me 12 month ka data bana sakte hai aur dekh sakte hai month change kar kar ke Agar aisa ho sakta hai to ek video upload kare

[@praveentechbaitha6347]

Month wise attandance change nhi ho rha

[@ranjeetsamal1719]

month change karne se and P & A change karnese sare month me change hu jata hei

[@thumbnailForyoutube]

Bhai koi bhi pahle hi kisi ka baare me nahi pata laga sakta ki kab kaun aayega kab kaun absent karega

[@CVSingh-hf7kq]

Bhai sahab month wise Attendance Chenge nhi ho raha hai only date, & day Change ho raha hai

[@sherazahmed5533]

AGREE I HAVE SEEN MANY TUTORIALS THE ATTENDANCE REMAIN SAME ONLY YERAS MONTHS GET CHANGE, SO THIS IS USELESS.

[@SADBOY-ro4ob]

Drop down krne pe January ka February March ka bhi p aur a same aa raha hai dono me

[@PowerExbyJitendra]

Data same same filled hai na isliye

[@SADBOY-ro4ob]

@@PowerExbyJitendra ha par mai 😍🥰 apke skill ka fan hu sir bhut accha skill hai apke pas

[@PowerExbyJitendra]

It is so kind of you.

[@mhhasan2005]

Sir, Countif Absent ka function check kareye aap shayed lock nahi kare shayed. Thanks

[@ritukiran5129]

Phone no.sir.freelancing se work from home ke liye ye useful he

[@samaatif173]

1 se 31 tk colums widht aur height kaise change kiya ye kon batayega tumhara baap 😂😂 Nasa kar ka video banaya hai kya😂😂

[@firojex.ibra786]

Your video was good But after implementing this all when we change month the absent and present remains Why? Try to resolve it

[@PowerExbyJitendra]

Please create a copy of this sheet and delete the data

[@PowerExbyJitendra]

You are absolutely right. Thanks for clearification.

[@seeratkaur5456]

@@PowerExbyJitendrasir mujhe abhi bhi smjh nahi aaya …12 sheet mean?

[@sherazahmed5533]

@@Office-Monk do you have such sheet available? if yes please answer

[@Office-Monk]

@@sherazahmed5533 Yes. Btw what all are you looking for, in your Attendance Sheet ? Jitendra has a vast knowledge of Excel. He will surely create such an Attendance Sheet / Format will will fulfil all your needs.

[@gopaldass632]

Sir month change korne se pichle month ka attendance next mont me show kar Raha hai

[@chamilatharuka9274]

Yes

[@user-xh4od2ht8k]

Hai papi choolo yeah Kiya hogiya....😂

[@mdsulemanrehman2143]

Bhai ya log sahi tarha nhi batate hai

[@ABiR-c7b]

Apps er name?

[@SURAJKUMAR-yx3be]

Aap me change hota hai

[@SURAJKUMAR-yx3be]

Or my kar raha hu nahi ho raha hai

[@jayanthamadasekera8248]

👍

[@saifullahelectronics8513]

Please give file permission

[@SantoshSingh-g1u8j]

Sir aap bahot धीरे bolte ho kuch bhi samjh nhi aa raha hai mujhe

[@OmarFaruk-fm2kj]

government holy day color need

[@user-xh4od2ht8k]

Paint 🎨🖌️

[@saifullahelectronics8513]

İ sent request

[@COCgamingworld]

But when i change the month the previous date is still there

[@muhammadariffiaz9260]

sir i need to apply a formula when we enter 9:15am then automatically mention "p" & when we enter 9:20am then mention "L" please help

[@pritammandre]

SIR But Month change karne ke bad vahi attendence dikhte hai