Комментарии:
Thanks 👍
ОтветитьHello sir
ОтветитьHello sir mujhe excel sheet par ek formula puchna tha ek number ek month me 2 bar aata h Un dono number ke bich me jo distance h (Maan lo 2 date ko 29 aata h or 6 din Baad fir aata h) tho distance 6 din ka hua tho mujhe formula chahiye ki me formula lekh month me or jo jo number 6 day ke distance me aaye pata chal jaye 🙏
ОтветитьMid ka formula ni pta chal rha h
ОтветитьHello @Deepak, The way of explaining is very good and a lot of effort has been done. I appreciate your hard work. But in the case of salary, the standard days which are counted would be 30. And if the salary is made according to the days of each month as you show in this video, then it will be less and more every month in case there is a holiday deduction
ОтветитьHi
ОтветитьI am also in a situation to use these new techniques in MDM reporting, Results and so on. Hope you will guide us as it is in future too. Thanks 🙏🙏 again Sir ji.
ОтветитьIt's too interesting and informative as always sir ji from Suresh Ram Patiala Punjab India ❤❤
ОтветитьTime NAHI ha
ОтветитьMashallah
ОтветитьSuper sr
Ответитьसुपर सर
ОтветитьMujhe formula hintoh seekhna hain.. copy paste kyun karu
ОтветитьHI Mr Deepak , Many thanks. Excellent presentation with very clear guidance. I need some help
ОтветитьHow to calculate half days in salary calculation
ОтветитьThx. Please this attendance sheet given to you
ОтветитьSir is m jo 255 type Kia h bo kya h
ОтветитьExcellent sir.please forward the sheet to me
ОтветитьSir send kar dena
ОтветитьDeepok nahai karaha hai
ОтветитьHow to change year in this datavalue formula
Ответитьkindly send this sheet to me as soon as possible!!!!!
ОтветитьBhote badiya give me .
Ответитьin the same video can i make pay slip for each month each employee by adding another sheet ?
Ответитьas per the video, i prepare the attendance cum salary sheet but how can I generate salary slip in a sheet for any months .
ОтветитьTo Make Attendance Sheet With Salary In Ms Excel is very very good and suparb, aswom . Would be more wonderful if linked with the detailed salary sheet and salary slip as well..!! So which formula should we use? Thanks 👍
ОтветитьSir pls send
Ответитьreally nice video and cool attendance sheet ! Deepak bhai
but one error i feel present in this sheet
which you either ignored on purpose
or ?????
we have selected and generated base sheet calculating 31 days month
and if we select 28/30 days month
we have extra rows as per 31 days month present / visible with formatting we have done.
kindly help me to sort this issue
so that this sheet goes completely automatic
also let me know more important and basic things which can help me in my job
i work in school bus service providing transport sector
there are quiet many aspects which are bit different
compared to other industries.
yi PS kia hy sir smj ni ayaua or na r per day amount smj aya
ОтветитьHello sir
I have a question in salary payroll master like what formula should i need to use in given conditions
If Medical leave is 03 in a month we will consider it as medical leave and we will pay for it
If the medical leave is 04 in a single month we will consider first 03 medical leave as medical leave but 4th one would be absent
How can we calculate to add this 4th medical leave in Absent column
Please solve this issue
Great information 😊😊
ОтветитьHello brother meray wo formula nhi lg raha jo apnay description ma dia hai mai jb formula type kr k enter kia wo waisay he rehta hai formula? Please give me solution
ОтветитьHello sir mene aapki ye video dekhi achi lagi lekin ekk baat batao salary sheet to hum financial accounting ke hisaab se banate hai to yaha aapne year ka formula bataya hai usme 2022 ke baad last ke 3 month 2023 kaise aayega please bataye
Ответитьsheets name formula is not work
ОтветитьAttendance sheet bhejna
ОтветитьTnx ❤
ОтветитьDeepak sir this the formula that you have provided us is no working
Ответитьdear depak nehra, mujy aik formula sekhna hai.. mujy ye btayen k presents counts to ho jayen gi lekin me un presents ko esay likhna chahta hun "1-5, 7-30 Sep 2023" yani k 6 Sep 2023 ki absent nikal kr.. Kindly help me.
ОтветитьCAN U PLS SEND A
EXCELL SHEET
Mujhe bhi bhej do na bhai
ОтветитьHii...sir
Please send current year worksheet with pf esic also
❤❤❤❤❤ thank you sir❤❤❤
ОтветитьHi sir
I need this sheet
Hi
Ответитьi need this sheet
ОтветитьSir ,if we put value as "P" when there is Sunday,then it count it along with regular Sundays,,,and salary of extra days paid up,,,,sort out this problem
Ответить