Video

Thanks a lot MK

Dont understand why you added a holiday column , there could be more than one holiday impacting the delivery date and only one is appearing in the cell ➡️ Holidays and weekends are for PLANNING and not for delivery dates. What does top sheet do ➡️ Instead of working in boring Excel Formats, it makes format more interesting. It totally depends on person to person what he or she wants to put in the format. and weekly ,, monthly tabs are supposed to do what ➡️ Some people plan for Daily, some plan for Weekly and some plan for Monthly. Even some plannings are done Yearly and 5 yearly. Again it totally depends on your preferences and need of hour. Thank God, you haven't asked Why I used Bright Colours ? Why I used specific fonts Why I used only those functions and formulas and not others ? Why haven't I created this in Ms Word or PPT ? List of your queries may me long. Many things may be useless for you in the format but for many people it's beneficial. Seems you haven't liked anything in the format, only reason no appreciation came and list of negative highlights were quite long. Thanks for the comments. Stay smiling 😊😊😊

If you want the format to pick-up all the things automatically then you will have to do the entry in 2nd Sheet. In case you want to do the entry manually, just delete all the formulas in paid days and all the entries can be done manually

@@Office-Monk how sir ?

Please mail me your contact number

Thank you so much for the appreciation. It really means a lot

@@Office-Monk Please, can you make total paid for each month? I mean the sum of the fees which all the students paid in one month.

Hi Shivam, You can join the Channel Membership to download this format

@@Office-Monk how can I get it

@shivamtiwari-sr9po below is the link to join the Channel Membership. Once you join the Channel Membership drop a mail on vijaymuukh@gmail.com czcams.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin

Vstack is available only in Ms Office 365 and not in other Ms Office versions

Please put Sum

@@Office-Monk Thank you for quick response however I am getting error for both countA and sum .. error is there are more circular references where a formula refers to its own cell either directly or indirectly

@Indianlucknawi vijaymuukh@gmail.com Mail me the format. I will check

​@@Office-Monk It got resolved.. thank you so much ... I have one more question.. please in holiday I have calendar for 3 different region where some holidays are common eg. New year and for some dates are common but different holiday how include in the list

@Indianlucknawi New year, 2nd holiday, 3rd Holiday You can do this. The other way is to create filtered list as per region. When you will change the region, all the holidays will change

Once you join the Channel Membership, I will share the Excel Sheet, which you can use till you want

@@Office-Monk IF MY MEMBERSHIP EXPIRE THAN ALSO I CAN USE IT SIR

Whatever format I will share, it will be all yours. It will not be protected. Use it till you want, it has nothing to do with Membership expiery

@@Office-Monk sir I had join membership can u send me now

@@MYSTERY_FACTS922 Please drop me a mail on vijaymuukh@gmail.com

Thank you so much for loving the video and getting connected with the Channel 😊😊😊

Sure. Will come up with such a format soon

Drop downs se months Change karne se data delete nahin hoga. Drop down create karne ka basic reason ye hai ki aapko Months ke name baar baar type na karna padey. Agar aapne Video gaur se dekha hoga toh maine ye kahin nahin bola hai ki Drop Down se months change karne par saara purana data erase ho jayega. 12 months ke liye 12 sheets create karne padenge aapko

@@Office-Monk nhi bro meny kisi aor k channel se d3kh kr bnai h, data delete nhi hota, data khud ba khud doosri sheet pe copy ho jata h means k jab me aik employee ka name January wali sheet me likhta hn aor os k baad jb os ki present and absents lgata hn to wo entries saari khud ba khud January se February march... December wali sheet pe copy ho jati h aor jb en se ye data erase krta hn to pehly wali sheet se bhi data erase ho jata h plz aap mjhy btay es baary me agr aap ki koi video h es pe fully automatic attendance sheet pe kindly plz mjhy send kry video ka link mjhy bohat zaroori chaiyeh plz bro

@@Office-Monk bro data delete nhi hota balky khud ba khud all sheets par copy ho jata h agr January me kisi employee ki present lgaon to wo bkaya month me b present lag jati h

@@Office-Monk meny aik dost se aap ka channel liya h os ne mjhy aap ka link dya h channel k yaha se aap ko information mil jaygi jo aap ko chaiyeh to plz bro mjhy video ka link send kry jo aap ne fully automatic attendance sheet bnai ho

vijaymuukh@gmail.com Aap apna format mail kar den. Main check kar lunga ki issue kya hai

Thank you so much for the appreciation. As you asked, why the format is shared if one can't download ? I have shared Video too and in the video I have described in detail, how to create the format from scratch. Now my question from you, why can't you create the format by watching the video ? Why you need to download the file ? Take some pain and put your effort In the description box of the video, from where you tried to download the file, I have clearly mentioned that file download option is only for Channel Members and you will have to join the Channel Membership to download the file. You even didn't take the pain to read what was written over there. Really awesome. You can create your own format by watching the video and in case you face challenges with the formulas, I am always ready to help and for that I will not ask you to join the Channel Membership. Thanks

Thank you so much for the appreciation 😊😊😊

Thanks a lot Ramesh for the appreciation. I have my Hindi Channel too by the name of Office Freak You will get all these videos in Hindi over there

czcams.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin Click on the link and you will be diverted to join the Channel Membership. In Channel Membership Levels, you will get a level of PPM Tracker Download. Join that level and drop me mail on vijaymuukh@gmail.com I will share the Excel file

How can we fix the now function ( one time time is filled then no changes in this time )

Go to File Tab, on the left hand side you will get the option of Formulas. Click on Formulas, now come to right hand side, enable iterative calculation. Do Maximum iterations as 100

Thank you so much for the appreciation. It really means a lot. Please stay connected for such interesting formats and videos

Hey Excelpaaji, I use inbuilt software of MacBook for screen recording and imovie for editing videos. Sometimes I use inshot too for Video Editing

Thank you so much for loving the video and getting connected with the Channel 😊

Thank you so much for loving the video and getting connected with the Channel 😊

Are you talking about follow up sheet ?

Thank you so much for loving the video and getting connected with the Channel 😊😊😊

vijaymuukh@gmail.com Please mail me your format. I will check and will let you know what's the issue

Sir, I have sent in mail to yourself.

I am not able to download the file. Please send a new mail and also mention all the issues you are facing in the format

PayPal and GPay link is in the description box. Please do the payment and drop me a mail on vijaymuukh@gmail.com And I will share the Excel Sheet

I will try to come up with such format soon

Noted all the points. Will try to work on this format soon

Pay for what ?

vijaymuukh@gmail.com Mail me your format. I will check

Excel link is in description box

Noted. Will try to create such format soon

Thank you so much 😊😊😊 Please stay connected for such interesting formats and videos

Hi Wasim, I shared the file on Mail. Please check

Download or edit access is only for Channel Members. Please join the Channel Membership to download the file

Ideal Working Hours: G6 Time in is in - H6 Time out is in - I6 Formula for Total Working Hours: =IF(I6="","0",IF(I6>H6,I6-H6,1+I6-$H$6)*24) Formula for Total Working Hours: =IF(J6="0","0",(J6-$G6)) These are the Cell reference numbers and the formulas. I will cross check in case I missed something. Thanks Akash

Thank you for updating the sheet.

@@akashchhabra555 Most welcome 😊😊😊

To download the Excel File, you can join the Channel Membership. Link to join the Channel Membership: czcams.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin

Thank you so much for loving the video and getting connected with the channel. 😊😊😊

You can message me on my Instagram

I shared the format on mail. Please check

Download or Edit access is only for Channel Members. Please join the Channel Membership to download the file. Link to join the Channel Membership: czcams.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin

Will try in next format

@@Office-Monk can't wait, thanks 🙏

Remove the Column from where you have to select Yes. Directly put the time in the cells

@@Office-Monk Sir I use the Other way in which I go at option setting then Under CalculatIon options, check the box for Enable iterative calculation after that I apply same formula I want to confirm that is this way OK like when I close file time i punch will remain the same it will not change

@@sidramustafa8711 enable iterative calculations and put maximum as 1

@@Office-Monk Sir Maximum number of iterations is 100 and Maximum Change:0.001 What column should need to be 1

@@sidramustafa8711 Maximum number = 1 Maximum Change 0.001

Download or edit access is only for Channel Members. Please join the Channel Membership to have the access. Link to join the Channel Membership czcams.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin

Thank you so much 😊