How to Create an Automated Attendance Sheet with Salary Calculation in Excel

How to Create an Automated Attendance Sheet with Salary Calculation in Excel
This video explains how you can prepare Fully Automated Attendance Sheet in Excel. It is also explained that how to prepare Salary Calculation Sheet along with attendance sheet.
So watch the video and if you find it valuable please subscribe our channel:
/ powerexbyjitendra
You can download our file:
==============================
docs.google.com/spreadsheets/...
==============================
Related Videos:
1. Drop Down List In Excel Hindi
• How To Create Auto Upd...
2. If Function in Excel in Hindi
• If Function in Excel i...
3. COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel in Hindi
• How to use COUNT, COUN...
---------------------------------------------------------------
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#attendancesheet
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks

[@maeraquiza]

I couldn’t understand a word but I managed to make this whole thing. Thank you! Very easy step by step process

[@PowerExbyJitendra]

You are welcome 😊

[@bittu25]

Thank you very much here are some new functions for me.

[@angelinarrr15]

Great bro,,,,all previous doubts cleared

[@dilipchauhan154]

I impressed with your video..i like it.

[@Soulserenity02]

You made life saver video 😍

[@arunpatel966]

Sab alag aur sabse saral aap ne explain kiya hai... Thxs for support

[@PowerExbyJitendra]

Thank you so much Arun ji

[@footballaction9855]

Those videos are so useful . Thank You Sir

[@RaselKhan-lf6ho]

please give me this file bro.

[@WasimKhan-mg5fm]

Absolute teaching skills thanks very much

[@PowerExbyJitendra]

Thanks 🙏 a lot

[@academyoflearning111]

Thank you for a such nice vedio. But if u don't mind how can we add gazetted holidies like sunday.

[@semponmanickam3746]

say if both saturday and sunday is weekly off how you will calculate it in google sheets? and also how to calculate for national holidays also?

[@nityayadav4063]

Thnku so much...your video help alot🙂

[@PowerExbyJitendra]

Thanks

[@niteshlanjewar6812]

Thank you sir

[@user-ri7rk7cm2b]

Sir, excellent video. Sir also tell in case employee is on half day casual leave, then how to calculate attendance

[@user-pu4vb8kv7m]

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 !

[@semponmanickam3746]

Hi if its saturday and sunday also leave how should give conditon?

[@dhanarajsivagnanam6283]

Very good work, even i don't know hindi, but i understood your guidelines. Thank you

[@PowerExbyJitendra]

Thanks a lot

[@nasirao786]

THANKS DEAR SIR

[@amoghplastic2503]

Hello Sir, Saw your video it was very helpful but wanted to know if a employee is taking a half day or if the employee is working entire day and then night how that will be managed in your excel sheet , can u please tell it.

[@oneup2022]

sir what if someone's attendance start in middle of the month say 14th day, in that case what will be the solution. thank you

[@sanjaysingh-un7rf]

Sir.... Your teaching method is very nice.. 🙏🙏🙏

[@PowerExbyJitendra]

Thanks a lot

[@premanandhagangiah1675]

Hi Jitendra, I need to have my month start on 26 of the month and end 25 of the month how can I do this

[@mithileshsingh184]

Nice update video sir

[@anupganguly9377]

Bhai.. agar Saturday nd Sunday dono off ho to data validation ke formula kaise use kare ..plz suggest..

[@GamingbyU]

Very nice
Thanks

[@PowerExbyJitendra]

Welcome

[@anilscorner3960]

Good info agar humne 26 se 25 tak ki dates ke andar ki time sheet banani ho tab koun sa formula use karna hoga

[@Urvii_fullylive]

Really helped me a lot and the way you explained everything was so clear

[@PowerExbyJitendra]

Thank you so much

[@manishajaiswal8874]

I have prepared excel in same format but now I am getting value error in date and day row. How can I fix that

[@abodisom_official]

Thank you🙏🙏

[@PowerExbyJitendra]

Most welcome

[@muhammadqaisar8777]

if its Saturday and Sunday also leave how should give condition?

[@prateekgoyal-dq2zx]

Plz tell aap months drop down box banane k liye last cell XFD3 per kaise gye.

[@Indian-un7gg]

Sir agr header par page no 3se start karna ho to kaise karenge

[@nhoemchandy2511]

Hello please make lists How to enter the year to issue 12 months

[@AJAYKUMAR-dj5lr]

Super Sir Ji

[@PowerExbyJitendra]

Thanks

[@24MovieMasala]

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.

[@karthikcatalystgroup9390]

Thanks bro

[@PowerExbyJitendra]

Welcome

[@reshmabansode3541]

Pls bataye agr emp overtime karta hai ya fir 2 ghante pahele hi chala jata hai toh kaise calculate karna hai

[@GamingbyU]

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

[@dailyjobsupdate5101]

Same question

[@mallikarjunasheeptransport3975]

Me to facing the same problem

[@sunnysuman08]

Cannot access the file... how to download the file link?

[@kyfparacha]

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.🤔

[@editjoshi]

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

[@sachinpal3650]

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

[@bhawanisinghrao1917]

Same esa hai iska lia kya formula hai koi idea hoto bolna bhai

[@vikasthakur-le7mr]

Sir Excellent video but absent and present in all months same please resolve this issue

[@Satishmali619]

Sir Automated Salary slip pr bhi vedio banaiye please 🙏🙏

[@el-dorado45]

Ye save rehega ya save karna parega

[@bikramdhiman8540]

it was good bro how to caluclate half days

[@aakashdev3808]

sir what to do if i want to double the pay on sundays????

[@muhammadyaqoobirfan1687]

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

[@PowerExbyJitendra]

Half days ke liye HD ener karke salary sheet mai 1 column increase kar le

[@dominicdcruz766]

Thanks

[@PowerExbyJitendra]

Welcome🙏

[@user-ko5rr7sg3d]

how to change employee name also month wise fully automatic

[@user-vp9di5kg5q]

for downloading i need access.please share excel sheet.

[@jansirani4926]

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

[@user-vm4um3mh7k]

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! 😢

[@pavan.kenchanagoudar1922]

awesome sir

[@PowerExbyJitendra]

Thanks 🙏

[@arunbukadiya2397]

If sir I change the month whole data same of previous month, when change it then change also privious data. How to solve it.

[@user-vm4um3mh7k]

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! 😢

[@Amarjit82]

Excellent but if how to Holidays can be applied like 15 Aug,26 Jan etc

[@PowerExbyJitendra]

Amarjeet ji you have to make changes as per your requirements

[@Amarjit82]

@@PowerExbyJitendra if you kindly update this I will.be highly thankful to you.

[@preetikanti7291]

Hi Mujhe over time salary ri ka bhi details me calculated kaise karna hai yebhi batasakte hai sir

[@sarbadasreekanth]

i am getting error it is calculating for 31 days and if i change month some columns are dispalying empty in attendance

[@atikwarsi4819]

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

[@chetangupta4243]

How to change financial year?

[@PANKAJKUMAR-ho6ex]

Sir agar 31 days wala month h like Jan ya March or one day absent h to kaise calculation hoga

[@waterandgarden646]

Hello , if we want to put condition in data validation for Saturday & Sunday off . what we have to put in formula =I$2"Sat" & "Sun" .. i tried like this .. it is not working .. can you please help

[@waterandgarden646]

pls do reply

[@lovelycharmdesucatan7742]

Im having the same problem right now lol@@waterandgarden646

[@avinashlokhande2601]

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.

[@nidanazirveharicampus2777]

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

[@candycrushsagapk4185]

czcams.com/video/xwXWEwunmf0/video.html

[@bhawanisinghrao1917]

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

[@rasmidapp7452]

Did you get an answer for this ! If so please share

[@keerthiraychandcute24]

How to calculate half day leave

[@arjitsingal4140]

सुपर 👌😃❤🤩

[@PowerExbyJitendra]

Thanks

[@cubeshipping9822]

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

[@cubeshipping9822]

Pls contact us and answer it

[@GurvinderSingh-yw3qd]

hlo sir
jab mai sheet bna rha hu toh #value!
error aa rha h
kindly help

[@ShahabSheikh-tj6tu]

Thanks u pls send attendance sheet during two month

[@Urvii_fullylive]

What to do if we need to apply 2 week off sat and Sunday both

[@PowerExbyJitendra]

Please watch it:
czcams.com/video/oAkbqLB2YLw/video.htmlsi=SPKocsYXWgz7IFqn

[@sanketpanhalkar507]

great design 👌👍

[@PowerExbyJitendra]

Thanks

[@MDKHAN-ix1uk]

February month pe formula apply nahi ho raha kyun

[@mahato6128]

Awsome sir

[@PowerExbyJitendra]

Thanks

[@Karishma___Negi]

How to calculate with OT

[@hunnymodelll]

Sir pf basic salary prr nahi lagta hai 🙂 balki payble day salary pe lagta hai

[@Asfandvlog]

sir month kaise show hoty ha nechey excel mai

[@khushbupatel7735]

Sir download file nahi ho rahi he pless

[@SArobi-ue1bm]

Attendance +salary sheet+ over time akta sheet a 12 months er jonno auto kivabey create kora jai...? Er akta video den plz..

[@kavindrasingh8995]

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 ?

[@mdjobayerhossain2645]

good...

[@PowerExbyJitendra]

Thanks

[@mindcomputersakshartamissi2273]

Isme employee ka attendance bnane pr change nhi ho rha hai month change krne pr.

[@harpreetgujjar1984]

Bai ager data save rakhna hai to kaise kare

[@user-xd7hl3gm4k]

SIR agar sunday on ho to keya please yad se bata dena

[@07292111]

how to download

[@PRADEEPSHUKLA747]

1 absent hai uska kya kiye salary to Puri ban gayi lekin absent nahi less hua

[@saketkeyal6710]

what about nepali bs date

[@meenuraghav5897]

Hello Sir my name is meenu month ke according date nikalne par #value! Aa raha h solution bataye

[@NehaSharma-nf8nw]

सर मुझे टाइम के अनुसार सैलरी बनाना हो तो क्या करे जैसे ऑफिस टाइम 9 से 5.30 isme yadi offday ho to kese banaya

[@candycrushsagapk4185]

czcams.com/video/xwXWEwunmf0/video.html

[@storyteller-p6q]

but where to save data of months

[@abbasidrees3811]

I really like your video.Your teaching method is very good.
Make a video on how to calculate time ?

[@PowerExbyJitendra]

Thanks ji

[@muhammadikramrajar5299]

Hi sir main month ki 21st date sa next month ki 20 date tak la sheet bana chata ho for example 21st Feb to 20th march as ka formula

[@amirakram9744]

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

[@PowerExbyJitendra]

I think about it.

[@amirakram9744]

Thanks i will wait

[@georgen9755]

overwrite

[@successok7579]

Sir day galt araha h mere m ,,

[@itsmeussr6209]

can i use hindu calendar in excel?
iy yes, How?

[@durgeshsahu219]

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

[@editjoshi]

Hanji kese shi hoga plz tell me

[@durgeshsahu219]

@@editjoshi i don't know

[@BaljeetSingh-ih2gl]

Is ki salary slip Kase bnye

[@pkguide]

सर डाटा को कैसे सेव करेंगे उस महीने के लिए।फिर ड्रॉपडाउन लिस्ट से नेक्स्ट मंथ अगर सिलेक्ट करते हैं तो उसमें डाटा क्लियर हो जाए।

[@PraveenPraveen-um6xh]

Hai Brother, Your time sheet calculation is very excellent but, there are some mistake please check it

[@PowerExbyJitendra]

Hai Praveen sorry for the mistake, I want to request please tell me where is it?

[@PraveenPraveen-um6xh]

@@PowerExbyJitendra There are total 30 days in the time sheet, in which one absent day plus 4 days weekly Sunday holiday days total 5 days right now.
But, presence column list showing 26,there should be come 25 presence days and total payable 29 days

[@PowerExbyJitendra]

@@PraveenPraveen-um6xh Friend don't find such a minor mistake see how this video can benefit you?
I noticed that in blank column also I had updated the present status by mistake. So there is a difference of 1 day in the number of days of the present.
Please see the larger aspect of video.

[@user-ew7ue2fe8c]

IF SUNDAY IS OVERTIME?

[@RaselKhan-lf6ho]

Please give me this files

[@RKhdMedia]

sent your request on your mail, please give me this link, thank you