Brother format banane ke baad poore ko select karo right click Karo uske baad copy or paste waale option par click Karo new sheet ban jaaygi then Feb ya March click karna aur data do delete karrr ke Feb ki attendance likhna
Really help full if I change the month the same data is uploaded in all month kindly help if I Change the month that month data should viewed in the excel sheet so kindly help
I faced the same problem. Month changes but attendance from previous month shows day wise in the next month. How to solve. If it cannot be solved then this entire excel tips is flop! 😢
hello sir I want to ask something I've created the same sheet like this by watching your video but when I changed the month from January to Feb the same data that I've entered in the month is showing in the month of Feb is it possible that when I change the month it saves the previous month's data ??
Awesome video. But The values entered for a month will remain same even if we change the month, right ? Is there any way to make the cell values dynamic like if we change the month, also need the entries to be updated for respective month. Thank you again for the video !
My concern is what is the purpose of drop down list. If i can't change the month to add new attendance whitout effect of previous month data. So i have a request that do you know how to add new attendance by change of drop down list to new month and my previous month data will be saved whitout shuffle. I can counties in same sheet to add new attendance by selecting of next months. Pls answer if you know.
I faced the same problem. Month changes but attendance from previous month shows day wise in the next month. How to solve. If it cannot be solved then this entire excel tips is flop! 😢
If absent before and after public holiday with Sunday then calculate the absent of continues four day's Advise the Data Validation formula in Attendance sheet
Sir i have one problem kab hum sun ke liye conditional formatting krte hain uske baad data validation mai jakr sun mai data validation krne ke baad jab hum p or A mention krte h then change the month to sir sun mai bhi p or A apne app a rha h to sir ye solv kese kre
Nice vdo. I have a question. The month that are 31 and enter data, my sheet is working. But when I go to the month with less then 31 days, my entries do not delete automatically, How to fix this issue.🤔
Muje salary sheet main agar month main salary pay ki hai to date ke samane ✓ ager pay nahi Hui to usake samane "×" aisi tick automatically aani chahiye in Excel.
Aoa sir I have an issue while making Attendance sheet I have to enter half days must in present .absent.leaves.half days.question is how we can easily divide half days remarks plz
jitendra ji maan lo kisi employee ki joining hi 15th of that month hui to usey 15th se pehle aaye week offs ki salary kyu denge. aur na dene ke liye formula kaise work karega fir ?
Asalam o alaikm sir I have a problem...when i selct all cells to decrease their size...the size of only one cel is decreases while remain unchanged...plz guide me how i can do this...
When i put the value 'P' in january and save it and then change the month february in drop down list it shows 'P' in february also if i delete it in february then it aslo be delete in january what should i do for it
I couldn’t understand a word but I managed to make this whole thing. Thank you! Very easy step by step process
You are welcome 😊
Thanks
Welcome🙏
Absolute teaching skills thanks very much
Thanks 🙏 a lot
It's very helpful for me thank you so much 🎉🎉😊
Sab alag aur sabse saral aap ne explain kiya hai... Thxs for support
Thank you so much Arun ji
"Your explanation style is excellent, sir. I am learning from your videos very easily. Once again, thank you!" 🥰🥰
Sir present absent likhne ka baad month change krte hai to p or A jo January m likha hai vo same February me aata hai to feb ki attendance kesa likha
Did you get an answer for this ! If so please share
Same here pls can you change ans
Brother format banane ke baad poore ko select karo right click Karo uske baad copy or paste waale option par click Karo new sheet ban jaaygi then Feb ya March click karna aur data do delete karrr ke Feb ki attendance likhna
@@samgaming97 fir itni mehnat hi kiu karni waise hi sheet ban jayegi ..
Nice update video sir
Very good work, even i don't know hindi, but i understood your guidelines. Thank you
Thanks a lot
Great Work
Sir.... Your teaching method is very nice.. 🙏🙏🙏
Thanks a lot
Thnku so much...your video help alot🙂
Thanks
You made life saver video 😍
did you even try it.
I impressed with your video..i like it.
Thank you very much here are some new functions for me.
Great bro,,,,all previous doubts cleared
THANK YOU SIR
Gr8 superb is attandance sheet mn agr date wise attandance alter krny k liay koi data entry form ki video bna dain tu kamal ho jy thanks
I think about it.
Thanks i will wait
overwrite
Those videos are so useful . Thank You Sir
please give me this file bro.
Awsome sir
Thanks
Excellent but if how to Holidays can be applied like 15 Aug,26 Jan etc
Amarjeet ji you have to make changes as per your requirements
@@PowerExbyJitendra if you kindly update this I will.be highly thankful to you.
great bro
Thanks a lot 🙏
Please i need this please give access to doc
If we change the month data is not getting change accordingly... Please help to resolve this issue
Thank you🙏🙏
Most welcome
Really help full if I change the month the same data is uploaded in all month kindly help if I Change the month that month data should viewed in the excel sheet so kindly help
I faced the same problem. Month changes but attendance from previous month shows day wise in the next month. How to solve. If it cannot be solved then this entire excel tips is flop! 😢
Very nice
Thanks
Welcome
Thank you sir
thank you ,but if we want to sat and sun off want so what we can do?
Sir, excellent video. Sir also tell in case employee is on half day casual leave, then how to calculate attendance
Then calculate total number of working days i.e 30-absent -halfday/2
U will get yr answer
hello sir
I want to ask something I've created the same sheet like this by watching your video
but when I changed the month from January to Feb the same data that I've entered in the month is showing in the month of Feb
is it possible that when I change the month it saves the previous month's data ??
Same question
Me to facing the same problem
Really helped me a lot and the way you explained everything was so clear
Thank you so much
I have prepared excel in same format but now I am getting value error in date and day row. How can I fix that
Super Sir Ji
Thanks
What to do if we need to apply 2 week off sat and Sunday both
Please watch it:
ua-cam.com/video/oAkbqLB2YLw/v-deo.htmlsi=SPKocsYXWgz7IFqn
Hi i have big problem actually our woff is not fixable date/days when i change the date is not changed the daily payout method
Awesome video. But The values entered for a month will remain same even if we change the month, right ? Is there any way to make the cell values dynamic like if we change the month, also need the entries to be updated for respective month. Thank you again for the video !
Bhai.. agar Saturday nd Sunday dono off ho to data validation ke formula kaise use kare ..plz suggest..
Hello please make lists How to enter the year to issue 12 months
THANKS DEAR SIR
if its Saturday and Sunday also leave how should give condition?
Good info agar humne 26 se 25 tak ki dates ke andar ki time sheet banani ho tab koun sa formula use karna hoga
Sir apsent present lagane par har month mein show ho raha hai Or agar sunday hai tho usme bhi
Datavalue wala staring mai date set k liye jo use kiya wo ho nhi raha hai
awesome sir
Thanks 🙏
Gazetted Holidays ke liye kya kare
Sir ji
Ye save rehega ya save karna parega
Sir, I need your help. Maine September month ki attendance bnaya to wo attendance saare month me show ho rha hai. Aesa kyun sir. Please help
Same problem
sir what to do if i want to double the pay on sundays????
सुपर 👌😃❤🤩
Thanks
for downloading i need access.please share excel sheet.
Sir agar 31 days wala month h like Jan ya March or one day absent h to kaise calculation hoga
Hello in my office attendance cycle is from 26 to 25 how to do that
12:14 i am trying to fix the date with f4 but i don't know why my excel is not fixing it
What about Saturday off?
Process will be same
thanks sir.
Thank you for a such nice vedio. But if u don't mind how can we add gazetted holidies like sunday.
Plz tell aap months drop down box banane k liye last cell XFD3 per kaise gye.
Agar kisi ek date ko holiday hai to uska total days add hona chahiye yes or no , agar ha to uska formula kaise hona chahiye... please bataye
My concern is what is the purpose of drop down list. If i can't change the month to add new attendance whitout effect of previous month data.
So i have a request that do you know how to add new attendance by change of drop down list to new month and my previous month data will be saved whitout shuffle.
I can counties in same sheet to add new attendance by selecting of next months.
Pls answer if you know.
Pls bataye agr emp overtime karta hai ya fir 2 ghante pahele hi chala jata hai toh kaise calculate karna hai
Hi Mujhe over time salary ri ka bhi details me calculated kaise karna hai yebhi batasakte hai sir
Hi if its saturday and sunday also leave how should give conditon?
But First persona having one day absent so we need to deduct that amount from monthly salary, But you have calculated all 30 days, Can you fix it plz
Sir Excellent video but absent and present in all months same please resolve this issue
Thanks bro
Welcome
If sir I change the month whole data same of previous month, when change it then change also privious data. How to solve it.
I faced the same problem. Month changes but attendance from previous month shows day wise in the next month. How to solve. If it cannot be solved then this entire excel tips is flop! 😢
If absent before and after public holiday with Sunday then calculate the absent of continues four day's
Advise the Data Validation formula in Attendance sheet
Pls contact us and answer it
Isme employee ka attendance bnane pr change nhi ho rha hai month change krne pr.
good...
Thanks
I can't copy sheet please help me how I can do😢
Sir i have one problem kab hum sun ke liye conditional formatting krte hain uske baad data validation mai jakr sun mai data validation krne ke baad jab hum p or A mention krte h then change the month to sir sun mai bhi p or A apne app a rha h to sir ye solv kese kre
Cannot access the file... how to download the file link?
hlo sir
jab mai sheet bna rha hu toh #value!
error aa rha h
kindly help
Attendance +salary sheet+ over time akta sheet a 12 months er jonno auto kivabey create kora jai...? Er akta video den plz..
sir month kaise show hoty ha nechey excel mai
Sir pf basic salary prr nahi lagta hai 🙂 balki payble day salary pe lagta hai
Nice vdo. I have a question. The month that are 31 and enter data, my sheet is working. But when I go to the month with less then 31 days, my entries do not delete automatically, How to fix this issue.🤔
F4 se fix nhi ho rha?
Use it with FN key
@@PowerExbyJitendra thanks sir
Muje salary sheet main agar month main salary pay ki hai to date ke samane ✓ ager pay nahi Hui to usake samane "×" aisi tick automatically aani chahiye in Excel.
Sir isme half day attendance miss hai. use bhi include kardo
how to change employee name also month wise fully automatic
Aoa sir I have an issue while making Attendance sheet I have to enter half days must in present .absent.leaves.half days.question is how we can easily divide half days remarks plz
Half days ke liye HD ener karke salary sheet mai 1 column increase kar le
How to calculate with OT
jitendra ji maan lo kisi employee ki joining hi 15th of that month hui to usey 15th se pehle aaye week offs ki salary kyu denge. aur na dene ke liye formula kaise work karega fir ?
Mujhe auto attendance sheet me kuch problem ho raha hai, month ko change karte hi jo A,P,H, hai wo next month me bhi apply ho ja Raha hai . Pls help
Hanji kese shi hoga plz tell me
@@editjoshi i don't know
i am getting error it is calculating for 31 days and if i change month some columns are dispalying empty in attendance
it was good bro how to caluclate half days
IF SUNDAY IS OVERTIME?
February month pe formula apply nahi ho raha kyun
Sir download file nahi ho rahi he pless
SIR agar sunday on ho to keya please yad se bata dena
सर मुझे टाइम के अनुसार सैलरी बनाना हो तो क्या करे जैसे ऑफिस टाइम 9 से 5.30 isme yadi offday ho to kese banaya
ua-cam.com/video/xwXWEwunmf0/v-deo.html
How to change financial year?
Thanks u pls send attendance sheet during two month
Asalam o alaikm sir
I have a problem...when i selct all cells to decrease their size...the size of only one cel is decreases while remain unchanged...plz guide me how i can do this...
ua-cam.com/video/xwXWEwunmf0/v-deo.html
Sir how can I download
Link is in description
When i put the value 'P' in january and save it and then change the month february in drop down list it shows 'P' in february also if i delete it in february then it aslo be delete in january what should i do for it
Same esa hai iska lia kya formula hai koi idea hoto bolna bhai
Bai ager data save rakhna hai to kaise kare
how to download