How To Make Attendance Sheet With Salary In Ms Excel | How to Make Attendance Sheet in Excel Hindi

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