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.co...
==============================
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/powerexby...
Contact Us:
Instagram: ...
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

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

[@DREAMCATCHER-o1q]

IF SUNDAY IS OVERTIME?

[@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

[@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

[@tapasadhikari7603]

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

[@gowthamanother]

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 !

[@meenuraghav5897]

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

[@hunnymodelll]

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

[@nikhilteluguvlogs7316]

12:14 i am trying to fix the date with f4 but i don't know why my excel is not fixing it

[@9706838718]

Hello in my office attendance cycle is from 26 to 25 how to do that

[@Snmahaur]

Sir isme half day attendance miss hai. use bhi include kardo

[@NehaSharma-nf8nw]

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

[@candycrushsagapk4185]

kzbin.info/www/bejne/rqi7iHitqtOgnJI

[@PRADEEPSHUKLA747]

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

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

[@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

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

[@RaselKhan-lf6ho]

Please give me this files

[@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

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

[@BONANZAENTERPRISES-i8y]

please send me a sheet

[@BaljeetSingh-ih2gl]

Is ki salary slip Kase bnye

[@santhaligirl__99]

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

[@shubhamkanojia8040]

Same problem

[@SArobi-ue1bm]

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

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

[@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

[@07292111]

how to download

[@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

[@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 😊

[@anupganguly9377]

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

[@lalitpatil5375]

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

[@ShahabSheikh-tj6tu]

15 4 2023 to 14 5 2023 during two month attendance sheet

[@academyoflearning111]

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

[@sarbadasreekanth]

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

[@pkguide]

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

[@muhammadqaisar8777]

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

[@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

[@prateekgoyal-dq2zx]

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

[@aakashdev3808]

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

[@preetikanti7291]

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

[@PANKAJKUMAR-ho6ex]

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

[@mindcomputersakshartamissi2273]

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

[@vlogwithyatishkandhari6293]

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

[@Sourav_244]

Then calculate total number of working days i.e 30-absent -halfday/2 U will get yr answer

[@GIMSJhang-ff9uy]

thank you ,but if we want to sat and sun off want so what we can do?

[@RKhdMedia]

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

[@mrunal-x4y]

for downloading i need access.please share excel sheet.

[@ShahabSheikh-tj6tu]

Thanks u pls send attendance sheet during two month

[@SHINFOSERVICES]

how to change employee name also month wise fully automatic

[@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

[@nhoemchandy2511]

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

[@GurvinderSingh-yw3qd]

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

[@vikasthakur-le7mr]

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

[@reshmabansode3541]

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

[@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

[@SaymaSultana-w9m]

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

[@storyteller-p6q]

but where to save data of months

[@SonofJesus-r8r]

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

[@mohammadtauseef3748]

Baccho kyun galat bta rahe ho Sunday Bala formula nhi lag raha

[@PowerExbyJitendra]

But sir maine to lagakar dikhaya hai

[@mohammadtauseef3748]

Sunday Bala formula nhi lag raha hai

[@MDKHAN-ix1uk]

February month pe formula apply nahi ho raha kyun

[@sunnysuman08]

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

[@bikramdhiman8540]

it was good bro how to caluclate half days

[@saketkeyal6710]

what about nepali bs date

[@itsmeussr6209]

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

[@nityayadav4063]

Thnku so much...your video help alot🙂

[@PowerExbyJitendra]

Thanks

[@reshmabansode3541]

Sir aap ne overtime calculate karna nhi batya

[@Asfandvlog]

sir month kaise show hoty ha nechey excel mai

[@Satishmali619]

Sir Automated Salary slip pr bhi vedio banaiye please 🙏🙏

[@khushbupatel7735]

Sir download file nahi ho rahi he pless

[@avrpestcontrol2214]

Sir how can I download

[@PowerExbyJitendra]

Link is in description

[@chetangupta4243]

How to change financial year?

[@harpreetgujjar1984]

Bai ager data save rakhna hai to kaise kare

[@Karishma___Negi]

How to calculate with OT

[@Indian-un7gg]

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

[@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

[@arunpatel966]

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

[@PowerExbyJitendra]

Thank you so much Arun ji

[@dhanarajsivagnanam6283]

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

[@PowerExbyJitendra]

Thanks a lot

[@semponmanickam3746]

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

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

[@SaymaSultana-w9m]

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

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

[@academyoflearning111]

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

[@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

[@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]

kzbin.info/www/bejne/rqi7iHitqtOgnJI

[@keerthiraychandcute24]

How to calculate half day leave

[@successok7579]

Sir day galt araha h mere m ,,

[@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

[@el-dorado45]

Ye save rehega ya save karna parega

[@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

[@Urvii_fullylive]

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

[@PowerExbyJitendra]

Please watch it: kzbin.info/www/bejne/pXLOk6SCd5eMgtksi=SPKocsYXWgz7IFqn

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

[@GPSS-r6c]

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

[@KnowledgeInformation2005]

thanks sir.

[@zxt0004]

F4 se fix nhi ho rha?

[@PowerExbyJitendra]

Use it with FN key

[@zxt0004]

@@PowerExbyJitendra thanks sir

[@mdjobayerhossain2645]

good...

[@PowerExbyJitendra]

Thanks

[@bittu25]

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

[@niteshlanjewar6812]

Thank you sir

[@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

[@mithileshsingh184]

Nice update video sir

[@Soulserenity02]

You made life saver video 😍

[@nasirao786]

THANKS DEAR SIR

[@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

[@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

[@dilipchauhan154]

I impressed with your video..i like it.