How to make an automated attendance sheet in excel | Attendance and salary sheet in excel in hindi

How to make an automated attendance sheet in excel | Attendance and salary sheet in excel in hindi.
#attendancesheet #salarysheet #msexcel #computergyanguruji
Practice file download:drive.google.com/file/d/1DUq-...
Formula:- =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&" "&2020
Our second channel
/ computergurujitechnical
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
Excel VBA
• Excel VBA
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
CSS
• Introduction to CSS | ...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic

[@ishanarsh]

Simple and effective. Love it.

[@mr.mohsinadeel]

Sir awesome information. You are Great

[@foodexsrj9998]

thanks bro. Its helpful

[@MahendraPatel-xq8gl]

Aaj tak ka best vedio really Bahut hi ache se samjaya thanks

[@indranilchatt12]

Very very good to learn new things.

[@sapnajaiswal404]

It's too good thank you so much 😊

[@arqnagauri]

Thank you very much Guruji, you are awesome, really wonderful.

[@shivarajhugar8915]

Very useful and fantastic method thanku sir

[@tmdasan]

Hi thank you for your simple & good tutorial

[@Tamilneasan]

bahut ache samjaya sir thank u sir

[@BS-Writes]

Excellent and simple

[@gaganvishwkarma8286]

Nice Sir, So Amazing.

[@aimranbcs]

Awesome one 👌👌👌

[@bittu25]

Thanks informative video

[@learningcenterHD]

wonderful and good job

[@birennayak1179]

Thank u sir ..

[@tapashalder4336]

Thank you sir

[@carryinsaan2159]

Bahut zabarjast sir

[@kishorpanara4191]

Excellent sir

[@Altaf_Alam]

Thank u sir 🔥❤️

[@satishcomputersportsedu.9440]

Mind blowing sir🥇🥇🥇🥇🥇🥇

[@user-pl7ly2dw3h]

Superb..... 👍👍👍

[@gaurfeels6095]

Amazing sir

[@subashmandlecha8278]

अच्छे ट्यूटोरियल के लिए धन्यवाद

[@ModiMaruti1]

THANKS A LOT SIR

[@muddsermayo911]

Great Video

[@officialvermaji92]

Intelligent 👍🏾

[@BS-Writes]

Absolutely, I did not make a mistake to subscribe your channel. I think you are the one from who I can learn and gain effortlessly because your way of teaching is so exciting and clear.

[@hafizdanial2738]

GREAT REPLY

[@neerajsharma2771]

You r good sir

[@gauravverma8727]

Thanku sir

[@deepakakyadav90]

👍 great

[@elambag4920]

Thank you

[@naveenkumarsingh7427]

Bahut achha

[@hiteshshah9470]

Very nice

[@keerthiraychandcute24]

Thank you so much sir How to calculate half day sir

[@rajanphadke9273]

Thanks sir for very useful video of attendance . Will you pls show us 9:00 AM to 5:30 PM working where 0:30 mins for lunch time and if worked Overtime this will be of gr8 help as I prepared it myself but it has some limitations Pls sir 🙏

[@mahjuja744]

GOOD VIDEO

[@preetimandal6688]

Find out DA 15% on basic salary only for those who belong to HR department and 0 for other.sir please solve the question

[@snehakumar28]

Nice

[@kalaidas5155]

❤️

[@muhammadkamran8555]

زبر دست بھائی، بہت اچھا. ایک شیٹ بنانا سیکھا دیں کہ ٹائم کیپنگ شیٹ کو اٹینڈنس اور سلیری شیٹ سب کو کیسے ایک ہی میں بنائں گے؟ کہ اگر کوئی سٹاف 3 دن لیٹ آتا ہے تو اس کی آٹومیٹک ایک لیو لگ جائے. جو کہ ٹائم کے ان آوٹ کرنے سے اس کی اٹینڈنس لگے. ایسی ایک مکمل شیٹ بنانا سیکھا دیں. شکریہ

[@niranjitsaha2626]

Please clear the confusion of - Back button

[@yogeshkumargupta8539]

Thanks you sir for tutorial, but one option add salary sheet my option add over time(OT) plz solve my query,

[@skt307]

sir company me kis tarah hota hata hai ek seriese banaye

[@saratkumar357]

Thank you🙏.. Sir! Great👍.. Please sir.. Upload a Auto PDF generated in bulk "payslip" & how to send bulk payslip through whatsapp on employees?

[@akrutishah5668]

Sir plz teach us how to animate in micro media flash 8.sir plz

[@mdnafisurrahman6957]

Dear Sir Heading ke saath jo Month and Year (January 2020) mein jo formula lagaye hain please wo bataiye Thank you

[@prabhatsaurabh8148]

Sir àapka video very nice aap to formula Ka sheet bhi provide kr dete hai other log Nahi karate hai

[@dakshbhatnagar]

What if the count of people who we are counting the salary for keeps changing?

[@asadrauf5902]

How to calculate overtime for the employees who comes in shifts, e.g. time in Monday 2:00 p.m. and time out is Tuesday is 1:30 a.m. where working hours are 9 hours a day.

[@rkdailydoses]

sir alag alag dates ki salary kese calculate krenge is par bhi koi video bnao

[@4everRanvir]

Sheet formula copy explain please

[@martandpangrekar2628]

Fully automatic bonafide certificate sheet kaise banaye pls bataye

[@user-rb2xd5zm3z]

attendance make need sheet with time in and timeout and overtime and Late then you make Present and absence then you make monthly Salary.

[@binaykumarsingh5453]

Pf esic format banaiya sir ji

[@dilipdwivedi4823]

सर अटेंडेंस में ओवर टाईम का या डबल हाजिरी या डेढ़ा हाजिरी का क्या फॉर्मूला होगा प्लीज इसका मार्गदर्शन करें

[@arvindmevalaljaiswal7234]

Dear sir. Type kare aur Surcheble drop down list banti jaye without right click. Please espar koi video banaiye.

[@4everRanvir]

Please explain sheet name formula properly

[@rdnsatbhaktisandesh3944]

=MID(CELL("filename",B2),FIND("]",CELL"filename",B2))+1,255) Sar Google sheets ke liye yah formula kam nahi kar raha hai #value aa raha hai sar Google sheets ke liye eisa formula bataye 🙏

[@amritrathod3941]

What can be the formula if we want to calculate employees rate per hours ?

[@amit9524]

Please tell me sir how to make weekly wages report

[@kishorpanara4191]

Sir isme mid wala formula samjaye pls

[@arvindmevalaljaiswal7234]

With time attendance sheet ban sakti hai.

[@yogira7039]

Same Sun mon ... Jo likhe hai waisa humko mobile se likhana k kis option me jayenge

[@suneelsharma6570]

Good after sir how we can lock the year and month when we change the the month or year first written attendance comes again and again

[@Udta-Parinda.]

Ji, February mein bhi 29feb k baad 1 & 2 aa rahi hai

[@KaranRaj-hw6yr]

Sir alag alag sheet na use karte hue ek hi sheet mein drop-down laga ke wahi ek hi sheet me all months ke report data store ho aisa kuch bataiye

[@ridoymahamud232]

How to count the no of students present in running date Sir

[@PawanNehra]

अगर मैं ग्रेड का sum करना चाहूँ तो क्या फॉर्मूला यूज़ होगा। उदारहरण ग्रेड a+b+a= a

[@SK-Bagravlog]

Sir is attendance sheet me v lookup formula se ek sath id se uski all details kese chek kare

[@sandeepmtopno]

Thank you Sir for sharimg. Need help in creating monthly bills for individual members of my society. Please share ur personal chat id so that I can share my file

[@ravishankersharma666]

sir my laptop me window 10 h kya is me formulas kese lgege.please btayen

[@user-iw6ii9fk3s]

Respected Sir, I want to make student attendance sheet with automatic update of time and date by clicking in single cell of excel sheet. For example at arrival of a student when I will click in cell in front of coming student that cell time must be shown as well as "p " for present and date at same time. Is it possible or not?

[@binaykumarsingh5453]

Data entry ka bhi

[@mukeshgehlot3251]

Itni simple cheezo ke liye bhi itne formula's use kiya hai sir apne toh 🤣

[@ravishankersharma666]

SIR Agr aap ki sheet me half day ki attendence lagani ho to kese lgai. please coment me btayen sir.

[@mukeshsanwan8147]

Sir, if hme 24 January se 23 February tk ki attendance sheets bnani h to date ka kya formula hoga pls reply.

[@SulemanKhan-lv1wm]

Sir jo january pa long wala formula lagya usko smjha da kasya lagna

[@srikantsingh5516]

Sir maine job January month ka present Dal ta hun,tabhi February month pe January month ka present show karta he

[@yogira7039]

Mobile se same ban jayega

[@umeshpatra2196]

Same date value ko ek sath aap kise fixed kiya, uski shortcut key kya hai sir

[@vedrawsinger]

Sir, When I shift this excel sheet into googel sheet., No months are visible and i am not able to work..what to change in this??😢

[@ronaasif7969]

Dear sir how we calculate overtime give each day 2 hours but here all in text P L H words

[@kashisharma7101]

Hi Thank you for good tutorial, however when I tried to mark leave for 1st of month and go to monthly summary to apply VLOOKUP formula. A message pops up saying "please enter correct date" but If I do for any other date it works fine. Where am I going wrong ?

[@bhupendrakumar-nx3xv]

Sir agar m sheet m month ki date dalu to designation wise count mile for example, mere pas executive, supervisor, Deo, Scanner h Or mughe data consolidation hoke mile ki 2 tarik ko kon kon aya h count m next sheet p bass us din ki date dalne p

[@rukku_khan]

Sir agar kisi employee ka half day hai to use kaise calculate karenge uske liye kya formula use kar sakte hai?

[@ComputerGyanGuruji]

nice, upload soon

[@manojdevdeharadun1956]

सर हमे परे साल का एक साथ टोटल दिखाना है कि किसने कितनी Leave ले ली है तो कैसे निकाले

[@zameerali6444]

Sir aise main apsent days one year main kitne days apsent hai

[@saahilsaahil5912]

=indirect ("'"&$A4&"'!d3:d3") sir Maine ye formula aaply kiya hai data extract krne from other sheet.. but sir other columns mein jab formula drag krna chahata hoon toh nhi horaha plssss sir kindly guide me.. mjhe har column bar bar formula lagana pardhra I want to drag it at once

[@creativeworkshop2353]

Sir date value funnse maine ek sheet banayi hai with drop down list . But how can change calander year to financial year in date value fun. As mujhe apr 21 to march 22 tak ki sheet banani hai. Plz help

[@sachinshukla3453]

Hello Sir, Greetings! My employees salaries are calculated from 21st to 20th of every month. So how i can put the date formula. Ex:- 21st June 2021 to 20th July 2021

[@nikhilkapoor82]

Same here

[@bhimpratap1139]

​@@nikhilkapoor82 You need to create a roster starting on the day that your first wage was paid [for example, from 21 to 21] and use the same calculation as for the months. 1 to 30 or 31

[@deepkharat8807]

Sorry sir but I am facing problem with salary payble when I divided salary with month days it Showing wrong pls help

[@guptabp]

Sir start date formula =date value( column ) error #value

[@ahmedmughal8943]

Assalamualaikum sir Main ye formula laga Raha hon nahi lag Raha hai Actual salary =Salary/Dom*working days Enter karny par 12 araha hi Ye kiyon employee salary 25000 hai

[@VimalKumar-rt4ic]

Sir isme jo starting m date ke second cell m jo formula fix kiya h vo kaise kiya plz btayie vo clear nhi ho rha

[@kone4870]

Sir excel sheet can’t useable in google sheet. Any solution.

[@mishtirajvideo719]

Hello sir mera newspaper ka shop hai mere newspaper customer ka automatically excel account maintenance kaise kare koi tarika bataye

[@ravishankersharma666]

hello sir mene sabhi sheets bna li h lkn oct or feb me error value show kr rha h please btaye ye kese hatega

[@syedshoeb3844]

foruula not working google sheet, please help me out for the same

[@latestcreations621]

Sir jb hum actual salary calculate kr rhe hai to DOM le rhe hai to ans error aa rha hai q?

[@eaton7331]

HAVING SOME ISSUE (ACTUAL SALRAY COLUMN)