😮 Create Fantastic Fully Automated 👌Attendance Sheet in Excel | Hindi

Easily create/make Fully Automated Attendance Sheet in Excel hindi - Learn How to Make a fully automatic Attendance Sheet / salary sheet in MS excel in Hindi. and how to use excel formulas to make a attendance | #salarysheet | #payrollsheet. this #attendancesheet is fully automated with some new features.
automatically fill months date.
automatically fill weekdays date.
automatic highlight saturdays & sundays for month.
automatic highlight absense and presense.
how to calculate leave charges
Payroll calculation
Video link for 12 months automatic attendance sheet with salary • How To Make Attendance...
New Date to Date Attendance Sheet video : • How To Maintain Attend...
Plz Also Subscribe My New Channel DEEPAK TECHWORLD : / @deepaktechworld
Download Training File drive.google.c...
1. Attendance sheet previous video : How to Maintain Attendance Sheet in MS excel in Hindi | How to Make Attendance Sheet In Excel. Microsoft Excel मैं Attendance sheet कैसे बनाते हैं Attendance sheet / salary sheet बनाने के लिए कौन कौन से formulas उपयोग मैं आते हैं और उनका उपयोग कैसे करते हैं इस Attendance sheet मैं हम calculate करेंगे Monthly attendance, Total Absence, Total Presence, PF, DA, HRA, Per Day Amount, Total Salary, In Hand Salary आदि
• How to Maintain Attend...
2. Excel - कुछ नया सीखो 😮 - Automatically Generate Month Dates 👌 Based On DropDown List HINDI. Automatically Generate Month Dates Based On Drop Down List in Excel Hindi. Its very easy to fill date of a months automatically on month selection from dropdown list. by using datevalue, if and eomonth functions. and this automatic date series is most usefull while creating monthly records. Automatically Generate Month Dates Based On DropDown List in excel 2007 2010 2013 2016 by deepak nehra [ deepak eduworld ]
• Excel - कुछ नया सीखो 😮...
3. HOW TO MAKE PAYROLL sheet IN EXCEL [ salary sheet / Payslip ] 2007/2010/2013/2016. Do you want to make salary sheet/ payroll sheet /pay slip /employee payroll report in Excel, do you want to prepare all salary data in excel but do not know how to make a salary sheet in excel then look no further. In this video you will learn to create a salary sheet in excel which has allowances, deductions, attendance, advance, pf, taxes ,etc.
Calculating - City Compensatory Allowance, Dearness Allowance, House Rent allowance, PF, Taxable salary, TDS, salery after TDS,
Excel मे payroll / salary sheet कैसे बनाए
• How to Create Salary S...
Hope you will like the video. Thanks for watching.
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
________________________________________________
ADVANCED MS EXCEL ► goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS ► goo.gl/bbHYu2
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER Tips & Tricks ► goo.gl/paZmpn
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Subscribe to my channel ► / deepakeduworld
Like my Facebook page ► / deepakeduworld
Follow on LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
**********************************************
Thanks for Watching
Happy Learning
ER DEEPAK NEHRA [ M.Tech. ]
**********************************************
Deepak eduworld, deepak eduworld excel, computer user, excel user, billing software, deepak eduworld hindi, hindi technology, excel tutorial,

[@DeepakEduWorld]

*New Video of Fully Advanced Attendance Sheet for 12 months* 👉 kzbin.info/www/bejne/ZnPHlGSOm9l0rcU Must Watch it 👌 दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰 *My New Channel :* bit.ly/3qFrbl5 *Complete Microsoft Word Tutorial :* kzbin.info/www/bejne/jpzUYWCujaadapo *Complete Powerpoint Tutorial :* kzbin.info/www/bejne/hZbOo3Weg96VhpI *Xlookup Complete Tutorial :* kzbin.info/www/bejne/Zn3Nl4WMeZymqLc *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb *Excel All Formulas :* kzbin.info/www/bejne/eWrcZmacmsmiZpY *Office Work in Excel :* kzbin.info/www/bejne/hoWbdWSnhtyYZ80

[@---tz2ug]

Hi

[@sushilyadav5805]

Sir g vba coading se related vdo bno koi jisme alg alg month ka data save ho

[@jyotimishra5796]

Sir 2007 me work nahi horha

[@arabindaghose2058]

Mr Deepak I am facing serious problem in setting the day and date and I am unable to go ahead in this video plz look to this and give me quick solution.

[@rubyshah3382]

Hello sir meri salary list me month by month present and absent change nhi ho rha h to kya krna pdega

[@mansinghkhanna487]

सर. बहुत अच्छा विडियो है, बहुत ज्ञानवर्धक जानकारी दी है, मैं एक बात जानना चाहता हूँ कि क्या ये डेट्स rows की जगह कॉलम में भी नीचे की तरफ सेट हो सकती है? दरअसल मैं एक विद्यालय में मिड डे मील प्रभारी हूँ. मैं चाहता हूं कि डेट्स कॉलम में नीचे की तरफ हो और rows में items आ जाए तो एक automatic mdm calculation शीट बनाई जा सकती है बच्चों की संख्या भरने से automatic per day consumption और automatic बिल भी जनरेट किया जा सकता है. आप के ज्ञान का प्रयोग करते हुए मैं 70% क़ामयाब हुआ हूँ फिर भी कई दिक्कत हैं, प्लीज आप इस पर एक वीडियो बनाएं. देश के लाखों प्रभारी आप के इस ज्ञान से लाभान्वित होंगे. धन्यवाद सर M. S. KHANNA CHAMBA H. P 7018462930

[@DeepakEduWorld]

Ys we can generate dates in a column.. 👍👍👍👍

[@DeepakEduWorld]

And i ll make a video as soon as possible 👍👍

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@AzharUddin-vg5ee]

Sir ap ni jo attendance sheet bena he ose m ek month ki results he next month ki results kese deki vo bate sir

[@bikashrajak9480]

Hi Deepak, I am also facing the same issue, I have prepared the attendance sheet and I understand the procedure. But when I have filled the attendance for January, some of the data from January will get reflect to the other month. When I will change the month from January to other. Please help us

[@rishabhjain9160]

And sir is there any way....which can inform us if we wrongly type any other word in the sheet except "P" and "A" ???

[@NatureAnimallover-786]

Im just loving yur videos, what if I need to highlight only Sunday ,then how can I do that., because you highlight sat,Sunday for weekly holidays but I need only sunday.can u help me please how to drive this formula..

[@anwarhossain9648]

sir, my keyboard f4 buttom if i clic dont lock my cell .how can i lock my cell plz im watting for your replay.

[@omigurmukhani1087]

Bana k google drive m dal k link post kro

[@Sachinchauhan021]

Sir this is nice but when i change month then presence and absence data will not change if you can give trick so it will work otherwise this sheet is totally waste and i also waste my time 🙄

[@dharmendrarawat2524]

Even I am also facing the same issue..do you know how to fix it?

[@manishrahulninejun]

Hi Sir, I am also facing the same issue... Could you please provide the solution.. I want to use this file itself

[@Munadas93]

Yes i am also facing same issue pls guide us asap .it will help me alot

[@7838881137]

Lakin sir shab kuchch Karne ke bad 1months complete hota hai to new file janret to nhi hoo rhi hai vahi wali file me Sunday Monday change hoo rhi hai plz sir shajesh Karo ki new file kaise open hogi Jan months last then Feb starting me ham kaise file kaare plz

[@DeepakEduWorld]

New attendance sheet for 12 months... kzbin.info/www/bejne/ZnPHlGSOm9l0rQ 👍👍👍

[@mmrameshkumar2279]

Hi Deepak, Seems there is a flaw with the automatic sheet. Pls assist with the query below, 1) If data is updated in the sheet (say P or L) of any month initially, the same would reflect in other months as well when we list down the months/change months. 2) How can we show empty columns for the coming month's when changed, so that attendance can be tracked accordingly. Hope to see your response soon. Thank You!

[@mmrameshkumar2279]

@Gauri Dhame No Sir

[@dipakbhowmik2339]

Same here. Did you find the solution

[@Learn_With_Fun.....]

I am also want know how to solve it please Deepak sir give us solution

[@masterjitoo]

Learn payroll from us

[@harisp338]

Yes sir .even I have the same issue

[@muhammadtalal4085]

Jb hmm new month lay tou absent or present sb clear hona chaie hay takay new chart pay entry karay

[@DeepakEduWorld]

Next video on this topic will come shortly

[@Panther09Playz]

Video toh pura banao yaar absent and present toh vaise hi reh jate hain fuddu wali harkatein mat karo yaar part 2 abhi tqk banaya ni

[@DeepakEduWorld]

kzbin.info/www/bejne/ZnPHlGSOm9l0rcU

[@Shivaniverma24317]

Very nice video.... very useful thank you

[@DeepakEduWorld]

😃

[@rajendrakumarsinwar6719]

Sir ak asi excel sheet banao jisme time In time out fir outomatic over time calculate hojaye.

[@darkwarrior1879]

Mila kya

[@officialsurendersaini]

Deepak ji 2021-22 per click show on the working list & 2022-23 per click the show 2022-23 working list khul jay. Please send video

[@muhammadtalal4085]

Bhai ap jab month change kar rahay hy tou sunday walay column may bhi Absent likha a raha hy is ka solution batai

[@DeepakEduWorld]

kzbin.info/www/bejne/ZnPHlGSOm9l0rcU

[@GovindYadavBarabanki]

Ek Manth ka Liv Apsent Dusre Manth Me Kyu Aa Raha hai

[@DeepakEduWorld]

12 Attendance Sheet deepakeduworld.com/attendance-sheet-in-excel/

[@pritam4you]

how to create April 2019 to march 2020

[@DeepakEduWorld]

kzbin.info/www/bejne/ZnPHlGSOm9l0rcU

[@jackyjigs2498]

Sirji Leave such as A(absent)for January month is again seen in Feb month...how to cancelled or delete reflected leave for next month....

[@setuanubhav8971]

सर, हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने absent present वही.डिटेल हमें अगले महीने में दिखाई देती है

[@DeepakEduWorld]

Please wait.. I will publish video as soon as possible on this topic

[@neerajchaudhary9860]

Sir plz give solution as soon as b. coz its very need full

[@neerajchaudhary9860]

Sir plz solve the query as soon as

[@40keshav]

Deepakji Namaste, I am facing the same problem. will be greatful if you can solve this major issue. I am also waiting for this query.

[@ashwini_makeup_artist_07]

@@DeepakEduWorld ak hi month ka data fill krte hai to sabhi me vahi fill hota sir solution to batao hame

[@Panther09Playz]

Bhai video puri nahi haj yaar Rest data next month select karne per toh wahin reh jayega Pls make part 2 now itne log bol rahe hain aadha kyun chhod rahe ho yaar

[@DeepakEduWorld]

Part 2 will come shortly 👍👍👍

[@Panther09Playz]

Sab ko yahi bola hai kiya ni bss

[@fitnesstools123]

NICE BRO I have one Query ki agar hum month change krte hai kya pichla data jo ki hmne pichle month attendance bhari this vo save rhega isme. ki har baar hme new sheet banaani padedi. matlab ye hai ki hmne is sheet ko bna liya hia attendance har mahina ki lagaani hoti hai agar baad me hame maan lo may ki attendance dekhni hai aur hum isi sheet se may month ko select krte hai kya hum may ki attendance jo fill ki this dekh payenge isme ki nahi

[@chandankumar-jk5fg]

KARAN SINGH .. it is most important question which needs to be answered. Hope Deepak ji will answer it

[@DeepakEduWorld]

Nice question.. Please wait. I will publish another video shortly on this topic.. Regarding your very nic query...

[@jikcomputers4889]

sir make a video early about this problem . We are waiting.........

[@suvendupradhan5458]

KARAN SINGH deepak sir same problem . The data which i prepared for may that is also coming on the month June. Pls tell us how to solve this.

[@RailLoVeRSaHaNi]

Deepak EduWorld when u publish new video on this

[@views-ml4yx]

Dear mery pas 2019, 2020 ki attendance sheets pary thi wo sb 2021 ki ho gai hain. Es ka koi hal bata den

[@prachandrakayastha4556]

Thank you very much, sir, for the most important tutorial you teach us. "Respect from Nepal"

[@baburao241]

If an employee has worked only say fir 10 to 12 days, then the above formula for payable days stands wrong. Since it calculates the other sundays also. So can u gv formula considering this situation.

[@bidyadharrabha4033]

Isko bananeka koi value hi nahi he kyuki date change karnese jo likha vo change hi nahi hota he to itna mehenat karne ka kya faida

[@sahilarya2306]

true

[@sonalithanekar7227]

Yes k koi solution nhi h kya. Baki sab achha h

[@nandanrana2676]

Sahi me bhai

[@masti_time5013]

@@sonalithanekar7227 vba use kar sakte hai

[@niveditapandey9023]

TRUE

[@nileshsuryawanshi2822]

Hi Deepak sir, I have prepared the same attendance sheet, but the data which we fill is getting overwrite in every month/ year and if we delete then also getting deleted from every cell. So, could you please help me out to solve this problem.

[@mahendrasharma-yh3qq]

same issue with me

[@mathewsenan8167]

how to extract only leave dates from this excel sheet using with formula.

[@shaishavchildrights9186]

सर, हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने absent present वही.डिटेल हमें अगले महीने में दिखाई देती है ples. reply kare

[@VedPrakash-cb9te]

Thanks sir but isme hamne January k month m presents fill ki to bahi presents next month m bhi fill rahati h. Aisa kyo kuchh upay sir...

[@DeepakEduWorld]

Next part of this sheet is coming shortly

[@lokesh686]

@@DeepakEduWorld i am facing same problem..

[@rishabhjain9160]

Yes same problem

[@vikaskatiyar007]

I have resolve this issue

[@poojachettri2200]

@@vikaskatiyar007 will provide us on the same

[@koonjbeharryradah290]

will the format work....if year changes...... n if yes......how shall we search for a month for last year then... plz help

[@sureshparmar1855]

LOWER SHEET FOR INDICATING "P" "A" NOT CHANGING MONTHWISE, ONLY SAT & SUN COLUMN IS HIGHLIGHED WITH COLOUR

[@DeepakEduWorld]

I ll publish next part of this sheet as soon as possible

[@shashikantbhide9185]

@@DeepakEduWorld YOU ARE PUBLISH THIS PROBLEM?

[@DeepakEduWorld]

kzbin.info/www/bejne/ZnPHlGSOm9l0rcU

[@manishrahulninejun]

Hi Sir I am also facing same issue... I wanted to fix the problem in same file... Can that be done

[@NaveenKumar-kd4ce]

@@DeepakEduWorld सर इस प्रॉब्लम का सोल्यूशन बताओ plz

[@dr.atultiwari4954]

It will not work next year. If I want to make an attendance sheet for next year I have to do every thing again because first date was chosen by month but not by year so it only took current year (2018 in this case). Now after 31st Dec 2018 we will begin with January it will reach to Jan 2018 instead of 2019 I feel. Year should have been there.

[@sandipkhanapure455]

सर, हमने आपका अटेंडन्स शीट वाला व्हिडीओ देखा व्हिडिओ काफी अच्छा था । लेकिन हमे कुछ समस्या थी । अगर कर्मचारीयो की विकली ऑफ अलग अलग है तो उसको कैसे हायले किया जा सकता है ।

[@shubhamwani3190]

play.google.com/store/apps/details?id=comm.example.takemyroll_teacher.takemyroll_ssw Sir, please try this app It will help you do all this with just few clicks.

[@smaranamatrakeshava3762]

Please mention WK off with a new colour as they assigned a separate colour for leave & absent , then search as WK off in table you will find your results

[@pallavis7729]

Please make video 📹 on cbse result text file. How can we get the subject code wise student data in excel. all in that file jumbled up...please guide or make video. If u want then I can share with u result. Txt file

[@Ravikumar-rd7cv]

Sir...when you change the month, the days and day is changing, but the details of absent and present is not changing .....what ever we enter in one month the same is being displayed for all the months?? Ravi kumar

[@DeepakEduWorld]

kzbin.info/www/bejne/ZnPHlGSOm9l0rcU

[@fencingjunction5406]

Why there is no allowance for Public Holidays (Paid & Unpaid/Half day & Full day) ?

[@infomipw9633]

Friend, Excellent way to transfer knowledge. learnt a lot, thanks

[@akansha123.4]

U r so intelligent.... thank you for sharing the video

[@BharathRajaNenavath]

Can you please create such videos using Apache Open Office....

[@sitakantasahoo7177]

𝙎𝙞𝙧 𝙞𝙩𝙣𝙖 𝙙𝙞𝙢𝙖𝙠 𝙖𝙩𝙩𝙖 𝙠𝙖𝙝𝙖𝙣𝙨𝙚......?

[@sirajgul9637]

Sir plz send me full formula mid cell("file name" etc.etc. sheet name automatically change

[@ankitgeorge8407]

What if we fill the entire data for the month of january and save the sheet, when we change the month to any other month other than january the data is also getting copied. Can you help me with this?

[@DeepakEduWorld]

kzbin.info/www/bejne/ZnPHlGSOm9l0rcU New 12 months attendance sheet

[@ankitgeorge8407]

@@DeepakEduWorld thank you

[@dirk20regz]

fully automated sheet yet no attendance record.. make it good enough for your subs. goodluck!

[@JuukoAqramJjunju]

Hello ..... Please translate to english for us who don't know Hindi

[@jackyjigs2498]

Good job.. Can I use this for student attendance also... Or need to change some format

[@pallavis7729]

Please make video on cbse result.txt file. How we can bifurcate subject code wise result of each student in excel

[@creatorajitmehra]

Dear sir. आप ने ट्रिक बताया वो बहुत ही अच्छा लगा लेकिन मुझे थोड़ा सा प्रॉब्लम हो रही है। क्या आप सर मुझे कृपया बतायेगे। जो आपने A L P की hightlight किया है वो हर महीने में बदल नहीं रहा है जैसे की मान लीजिये हम jan महीने में tue को{ A} ho or Wed ko bhi{ A} ho तो वो feb महीने में भी वही दिखा रहा है (A) ऐसा क्यू सर plz सर मेरा confuse दूर करिये सर ।

[@DeepakEduWorld]

Please wait.. I m publishing another video shortly l

[@iam_varunsharma]

How to undo Sunday Formula??? i want to show only red on where Sunday is return not whole row or whole column please guide

[@aftabhussain7750]

Month change karne ke bad data change ni hota ha dusra month ka Data dill karoge to previous month record delete ho jayega

[@shambhusharan8880]

Deepak sir, Maine sheet create Kar liya hai aur work bhi Kar Raha hai, lekin Jan. Ka feed Karne ke baad ab Feb. Ka data feed karta hoon to Jan. Ka data bhi change ho jata hai. Pl. Suggest.

[@savitadeshwal2810]

Fully automatic attendance sheet m attendance bharte time sabhe m same attendance kyon dikhta h

[@badgujardnyaneshwar]

Sir department vise daily absent & present agar piot table se nikalana ho to kaise nikalate hai Muze interview me yah saval puchha gaya tha Aur mai sahi se bata nahi paya tha. To isape koi video banaye

[@DeepakEduWorld]

I ll publish video shortly

[@badgujardnyaneshwar]

@@DeepakEduWorld deepak sir you're great Please sir mai is video ka intajar kar raha hu Aur ye video bilkul nai banane vali hai

[@aftabhussain7750]

Isme Ek issue ha, jab dusra month m Jana se pechla month ka data remove karna se pehla months ka data ka record to khatam ho jayega

[@AnjaniMusic01]

Are bhai time kaun bharega

[@abdulmatin2841]

When I change the month, p or a or l is not change. Auto replace. Please check the attendance sheet.

[@rupendra_0168]

Sir Aapka attendance sheet bhut Achcha hai but jab mai attendance sheet bna rha hu to January me present absence Dal rha hu to O Sabhi month me present absence aa ja rha hai, next month ka Pura sheet blank hona Chahiye n????

[@avinashkori1217]

Sr please esme ek aur formula add kr dijiye jisme next month change kre to sheet blnk ho jaaye and back month sheet selected kru to entry show kre Please sr

[@vinaymalviya4412]

2 and 3rd saturday chutti milti he bas usko heighlight karna he

[@Vivekkumarjagat]

Abest, present per month k liye different from kaise kare kyuki data per mnth same aa raha h....

[@edumentclasses6010]

THIS =MID(CELL("filename",B2),FIND("]",CELL("filename",B2))+1,255) IS NOT WORKING IT IS SHOWING ---- #VALUE!

[@DeepakEduWorld]

Plz save your excel file first

[@sandhyamr468]

Could you please help to calculate advance payment in this excel sheet

[@salimahmad4607]

1big problem pahle mahine me attendence lagane ke baad agle mahine pe select kro to wo bhi fill milta hai

[@designerboutique8270]

Thnks a lot sir but esme hum attendence kaise fill krege??

[@saikatshah4663]

Sir.., apka attendance list mea "A" "P" "L" month waise change nahi horahea..... Please suggest me....

[@DeepakEduWorld]

Attendance Sheet Download Link deepakeduworld.com/attendance-sheet-in-excel/

[@shivrajsinghrajput4790]

Deepkji, Very nice हम आपका हर वीडियो देखते हैं एवं कई लोगों को देखने के लिए भी कहते हैं मैं अटेंडेंस वाली इस वीडियो का ऑफिस में उपयोग करूँगा I will use in my office but I have one problem हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने absent present वही.डिटेल हमें अगले महीने में भी दिखाई देती है जबकि होना यह चाहिए की जब हमने current महीने की अटेंडेंस fill कर दी तो ये अगले महीने नहीं दिखना चाहिए अगले महीने ब्लेंक होना चाहिए एवं हम जब लीव काउंट करें तो monthwise count होना चाहिए उसके बाद पुरे वर्ष की काउंट हो जाये कृपा इसका वीडियो अपलोड कीजिये तो अच्छा होगा |

[@DeepakEduWorld]

G blkul.. Please wait.. I ll publish another video on this topic... Shortly

[@MAKhan-kl8on]

sir is auto matick sheet ka koi fayda nhi h. kyoki jis tarike se month change karte h to previous month ki present feel huwi sheet next month me change nhi hoti h. or previous month ki feel huwi sheet next month me bhi aa jati h to isliye auto matick sheet ka koi fayeda nhi h kya aap apna mobile number de sakte h

[@DeepakEduWorld]

I am publishing another video on this shortly..

[@MAKhan-kl8on]

@@DeepakEduWorld ok i wait you

[@MAKhan-kl8on]

@@DeepakEduWorld but aap bhut late se jage me sms to bhut din phale hi kar rkhe h. reply bhut late kiya aap ne.

[@ferozmd7942]

Very nice sir, very very useful to us, thank u very much

[@DeepakKumar-mx8xg]

Sir agar hm month change kar rahe hai to present absent bhi to change hona chahiye

[@sunitawelekar4416]

Sir namaste, आप बहुत अच्छे से बताते है, आसानी से समझ मे आ जाता है. एक प्रॉब्लम हो रही है, मैने Aug ki attendance शीट बनाई, जब इसमे month चेंज करते है तो aug का फिल किया हुआ डाटा sep मे भी आ जाता है. इसको कैसे ओके करें.pls बताये...🙏

[@DeepakEduWorld]

New attendance sheet for 12 months... kzbin.info/www/bejne/ZnPHlGSOm9l0rQ 👍👍👍

[@farheenakhtar5561]

Sir please iska print nikalna b sekha dye.. Agr itni bari sheet ka niklna ho print

[@sonovibe]

Bro how to make vacation sheet for two month

[@Abhishekdgaf]

All good I have prepared it but one issue is coming when I change the month everything gets changes except the (Present, Absent) but it should change similarly, otherwise in the next month how would I be able to enter new records, please explain.

[@Sohailshaikh251]

Yeah this is bug

[@lakhangoswami6401]

Bhai month cheng kar ne pe present apsent cheng kaha hui he check kar ke batai ye

[@nsjattu5313]

सर, हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने absent present वही.डिटेल हमें अगले महीने में दिखाई देती है

[@DeepakEduWorld]

Please wait i will publish another video on this topic as soon as possible

[@Dars_e_nizami-Duroos]

سر ڈراپ ڈاؤن لسٹ سے جب مہینہ تبدیل کریں تو شیٹ بلینک کس طرح ہوگی خود بخود؟

[@tbmsgsmartdapodi3900]

suppose i did any changes in month of may ..it reflects in April why ? it can be happen with any month ..if i do any changes in current month it reflects in previous.

[@DeepakEduWorld]

New attendance sheet for 12 months... kzbin.info/www/bejne/ZnPHlGSOm9l0rQ 👍👍👍

[@AjayKumar-wf7fd]

Deepak bhai aaj almost 1 saal yeh poochte poochte ke next video kab release karoge jo is sheet me defect. But aap hamesha bolte ke coming soon but it is almost year now but haven’t fixed it. If we change the month then it will copy the previous month data also. Please fix it as soon as possible thanks

[@DeepakEduWorld]

Ajay g... If we use vba to fix this issue.. then worksheet getting hangs.. i think that type of video will be useless if i publish for views... This sheet is good if you use it with creating copy of sheets for individual months .. i ll publish another attendance sheet video .. for complete one year.. without vba... And in next upcoming 2 or 3 videos... One will be this👍👍👍👍🏻👍

[@chetanjain8685]

But what's the use of the months other than showing the no. Of days. If I put absent for 1 employee in June on a random date ..and change the month to July..the same absent is carry forwarding to the same July month...

[@DeepakEduWorld]

Ya.. Please wait for next attendance video... Coming soon 👍👍👍

[@The_cmrawat]

SIR AGR SALARY 15 TO 15 BANTI HAI TO start dete or last date ke formula ko kaise change karenge ? or month b change nhi ho raha h

[@DeepakEduWorld]

Okay I ll make a video shortly on this 👍

[@deepikadips6153]

Sir if logical vala formula samajh nahi aa raha

[@akshayavarkar6757]

Sir मला tally ची पुर्ण महीती पाहिजे

[@uttamkumarpandey5669]

Hello Deepak sir Pl describe the attendance sheet 26 Jan to 26 Feb fully automatic sheet

[@DeepakEduWorld]

please wait .. i ll publish another video shortly on this topic 👍

[@lovewithgod948]

Isme present / absent month ke according change ni ho rha h Is problem ko solve kro sir take my whatsapp no. And suggest me plzz

[@DeepakEduWorld]

I ll publish next part of this video shortly

[@naveediqbaltanoli8272]

Good day brother I have a question that when we change the month day & date is changed but the other is remained the same for example January 7 one staff is absent we put absent and when we change the month that absent is not change it’s remained on the same column, how we can change all with month change

[@DeepakEduWorld]

New attendance sheet for 12 months... kzbin.info/www/bejne/ZnPHlGSOm9l0rQ 👍 Here is one More NEW Interesting video on ATTENDANCE SHEET kzbin.info/www/bejne/omeyg5ecfqqBers

[@mumtazkhoso5610]

Its put good effort no doubt it's most most effective but one thing more, for instance you are on month January you put so data however you move to February same data will be shown ? how to over come this issue ?

[@DeepakEduWorld]

Next video is coming shortly

[@kasunmadhuranga8547]

How to calculate overtime with attendance?

[@ASHOK-tw4lg]

VERY NICE VIDEO SIR. WHAT IS THE FORMULA IF MY REQUIREMENT IS STARTING DATE IS 26 JAN & END DATE IS 25 FEB FOR THE MONTH OF FEB.

[@DeepakEduWorld]

New attendance sheet for 12 months... kzbin.info/www/bejne/ZnPHlGSOm9l0rQ 👍👍👍

[@AshishKumar-tb5mm]

हमे माह बदलने पर उसका अटेंडेंस कापी ना हो ऐसा कोई फॉर्मूला बताइये

[@DeepakEduWorld]

Attendance Sheet Download Link deepakeduworld.com/attendance-sheet-in-excel/

[@tarulatabhatt4037]

Sir, pf is counted on basic or total amount ?

[@praveentiwari7283]

The attendance is not change as per month , we cann't compare monthly attendance so why we make this format ? we have simple format also.

[@DeepakEduWorld]

kzbin.info/www/bejne/ZnPHlGSOm9l0rcU watch this 12 months attendance video

[@Confidentialsa]

I am very disappointed, you did not complete this video from one year ago you are giving excuses. ‏ if there is no solution please tell us

[@DeepakEduWorld]

With vba... This can be completed... But worksheet getting hang's... So i have not publish vba part of this.. i am looking for solution without vba... Almost done ✔️ please wait for video

[@Akshayluvsu]

Thank you brother wish you all the best

[@anupampal9601]

Sir Jo apne ye automatically worksheet taiyar karwai h na usme hum jab August ka data bhar rahe h p, a to ye data sabhi month me dikh raha h mujhe sirf isko August me hi dekhna h plz urgently videos uploaded.

[@DeepakEduWorld]

👍

[@real714]

ham January ki attendance dalty hen to har month ki attendance wohi rehti hai jo ham ne January ki same dali thi

[@DeepakEduWorld]

I ll publish another video on this topic shortly...

[@vikaspant9880]

Sir, students/subscribers continuously ek hi query aapse pooch rahe hai, unki query ka answer toh de dijiye... nahi hai jawaab toh manaa toh kar dijiye...woh pooch rahe hai ki month change karne par data kyu nahi change ho ra ...agar aapne ni bataana toh mein bataa du apne channel mein

[@DeepakEduWorld]

Dear.. i have recently published video for 12 months attendance sheet.. visit channel...

[@bikramaggarwal4900]

PL. SEND UR EMAIL ID, EK PROBLEM SHARE KARNI HAI

[@hiralal580]

In my case the dates are not shown automatically why it is happening??? please tell me then what can I do ???

[@DeepakEduWorld]

New attendance sheet for 12 months... kzbin.info/www/bejne/ZnPHlGSOm9l0rQ 👍👍👍

[@fullentertainment7236]

How to make like 21 Jan to 20 Feb attendance in Ms Excel please suggest me

[@DeepakEduWorld]

please wait .. i ll publish another video shortly on this topic 👍

[@MaheshMahi-iy9rf]

Super thanks u r for update this video

[@sanoberrehman4966]

how to switch between sheets.when i sheet 2 and data validation and select but after that unable to go to sheet one..how to fix it?

[@DeepakEduWorld]

New attendance sheet for 12 months... kzbin.info/www/bejne/ZnPHlGSOm9l0rQ 👍 Here is one More NEW Interesting video on ATTENDANCE SHEET kzbin.info/www/bejne/omeyg5ecfqqBers

[@divyarani2747]

Sir aise sheet google sheet pe kaise bana sakte hai

[@nihashalid4219]

How to create a daily transaction in one sheet (opening balance, total, balance, advance)want day by day

[@DeepakEduWorld]

I ll Publish video as soon as possible 🤗👍👍