Thanks for comment. Plz you can record the journal entry on the other sheet on the basis of that sheet you can put the absent days here or you can refer that sheet here so automatically this cell will show the absent days.
thanks for comment dear. agar employees absence na ho it means deduction will be zero so Basic salary - deduction will return the basic salary. plz try in excel. any other question let me know plz.
Thanks for your nice comment. plz you will find absent days so you need to create a another column for finding absent days and then deduct the absent days from the net salary. (Also you can put condition like If the month is 31 or 30 or 28 then you will minus the present days from the above figure means 31-present days, 30-present days, 28-present days.
@@YadOnlinetrainingacademy. Ok sir.. Thnx..still some confusion. If you make a video on present days and absent days.. It'll be more beneficial to me.. Kindly make a video on this.. Sir.. 🙏
Muze iska hi doubt tha but ye video se mera doubt clear ho gaya. Thank you so much Sir🙂
Most Welcome
Thank you for making a subtitle! Badly needed this! :(
Most Welcome
i too like this.. its simple method.. i need this one... its more help of this my work and its easy to my work pressure... thank you sir!...
Thnku so much sir ❤❤❤
Most Welcome
It's very easy😊
Thanks a lot 😊
Zabar 10 sir thank you
Most welcome
Thank you its very useful.... Sir i have a doubt is this the same format of calculation im abroad??
Yes, definitely
You have considered the denominator as 30 days, but it should be (28 or 29) in case of February, or 30 /31 rest month days
Really helpful
Glad it helped
Pls tell what is the journal entry of this deduction?
Thanks for comment. Plz you can record the journal entry on the other sheet on the basis of that sheet you can put the absent days here or you can refer that sheet here so automatically this cell will show the absent days.
It'll help me if you can solve that for me as i have exams tommorow
Glad that it was helpful for you
If month is of 31 days
🙌🏻
Hello Sir, I need your help
How can I help you?
Sir i have a question related to days360 function. Where can i send you that?
plz let me know
@@YadOnlinetrainingacademy can you give me your email? I'll send the question there
Basic salary divide by 30 kar Raha hu to 4667 one day salary nahi aarahi h..plzz help me sir
Basic salary ka cell pa click karna hai aw phr divide by 30 karna hai
Agar employees absence Ho hi na pure mahina to
Absence days me zero rakheto zero hi aayega to ku6 nahi rakhe to b zero what to d
thanks for comment dear. agar employees absence na ho it means deduction will be zero so Basic salary - deduction will return the basic salary. plz try in excel. any other question let me know plz.
exactly
Yr net salary calculate krte time apne basic salary ko basic salary s hi kyu minus kia ?
I had the same doubt. i might have missed something but it doesn't make sense
Deduction ke formula me Mera e3 ki jagah d3 aaraha h..?or one day salary 1166.6667 Aaraha h sir please help me...🙏🙏
Sahi hai this cell reference
Sahi hai this cell reference
@@YadOnlinetrainingacademy 35000 salary to one day salary kitni hogi..?
35000divided by 30 = 1166.6667
@@anasansari5703 Its ok dear, you can simply calculate it on calculator plz check it out
If present day is given instead of absent days.. Then how we calculate total salary??
Thanks for your nice comment. plz you will find absent days so you need to create a another column for finding absent days and then deduct the absent days from the net salary. (Also you can put condition like
If the month is 31 or 30 or 28 then you will minus the present days from the above figure means 31-present days, 30-present days, 28-present days.
@@YadOnlinetrainingacademy. Ok sir.. Thnx..still some confusion. If you make a video on present days and absent days.. It'll be more beneficial to me.. Kindly make a video on this.. Sir.. 🙏
@@diptimayeebehera7152 Ok sure i will upload video on how to find out absent days and then find out the net salary.
@@YadOnlinetrainingacademy Thank you sir
@@diptimayeebehera7152 Most Welcome
Ek help h mujhe no dejiye
Plz comment your question
Sallery ki spelling theek krlen
Thank you so much for your comment
35000 =4667
30337??
35000=1166=29.150??
Sir call karna hai any contact number excle k liye cll krna hai