Grate sir thank you so much

Thank you so much for this explanation

@PowerExbyJitendra

Ай бұрын

Thanks a lot

Thank you very much 🙏

@PowerExbyJitendra

12 күн бұрын

Welcome ji

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

4 ай бұрын

Hello dear thanks for your lovely comment. 🙏🙏🙏

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

@PowerExbyJitendra

5 ай бұрын

Thanks a lot

Sabse sandar videos All Excel video sabse advance

@PowerExbyJitendra

5 ай бұрын

Thanks a lot

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

4 ай бұрын

Thanks🙏

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

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.

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

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

👍

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

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.

Daily & monthly production report for garments

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

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

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

4 ай бұрын

Same problem with me

@Office-Monk

4 ай бұрын

It's not a glitch. This format is for just one month. For 12 months you will have to create 12 sheets. If you want to blank the data, use Macros

@AFPTCentral

3 ай бұрын

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

@quotal9357

2 ай бұрын

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

@gopaldass632

Ай бұрын

Same problem

If we want to make from 20 to 20 than sir

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.

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,

Sirji pp entry karana hai to kaise formula hoga

New employees aad krenge to ho jayega

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

SIR I WANT TO KNOW HOW TO ADD HALF DAY?

Month wise attandance change nhi ho rha

Bhai ek daily deposit lene wali sheet banao 5 year ki

@PowerExbyJitendra

Ай бұрын

Ok I try

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

@PowerExbyJitendra

5 ай бұрын

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

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

@PowerExbyJitendra

4 ай бұрын

Please create a copy of this sheet and delete the data

@Office-Monk

4 ай бұрын

This format is just for one month. For 12 months you will have to create 12 sheets. In case you want to blank or delete the data, you can do it manually or can use Macros

@PowerExbyJitendra

4 ай бұрын

You are absolutely right. Thanks for clearification.

@Office-Monk

4 ай бұрын

@PowerExbyJitendra I have created many Attendance Sheet on my Channel and always get such comments. So thought to reply here too

@seeratkaur5456

4 ай бұрын

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

But sir when we change month data is not changed

@PowerExbyJitendra

4 ай бұрын

Because data is filled manually

@adonaishut1670

4 ай бұрын

How to link with raw data

@jogarupadhall9882

4 ай бұрын

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

4 ай бұрын

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

3 ай бұрын

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

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

@PowerExbyJitendra

5 ай бұрын

Data same same filled hai na isliye

@SADBOY-ro4ob

5 ай бұрын

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

@PowerExbyJitendra

5 ай бұрын

It is so kind of you.

@mhhasan2005

5 ай бұрын

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

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

@chamilatharuka9274

Ай бұрын

Yes

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

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.

Please give file permission

Apps er name?

İ sent request

government holy day color need