There is a problem, if you can help me, when we change the month, the old data remains. How can I make the data (P, A etc.) adapt to the selected month?
You will have to mail me the format which gets downloaded from Biometrics. Based on that I can create a format. So that you will have to copy paste the Biometrics data in Excel format and all the components will be calculated
In Excel, if we move one heading below one heading in ABC row, the size of two headings changes. If you move the ABC row, the size of the heading at the top should remain the same. The heading below should be resized and changed. Tell me how to do this.
Hi , Vijay How to calculate difference value between two no#, like there are only positive value and negative values. Ex: 5300-5200=100 ,which is 100 deficit 5200-5300 =-100, which is 100 surplus, can you please help out ..any formula for large data ..
i've create the sheet completely. However, when i choose February, the column data for date 30,31 from January still appear. Please advise what should do ?
Hi, Please check your mail. I have shared the link. In case you are not able to see my mail, please check your spam folder once. Thanks a lot for joining the Channel Membership.
Hi, hope you got the formats what you were looking for. It's not a scam. Files online have got only the option of view. I send the formats to Channel Members through mail. So it's not any type of scam. If you haven't received the formats yet, please drop me a mail
There is a problem, if you can help me, when we change the month, the old data remains. How can I make the data (P, A etc.) adapt to the selected month?
Hi Bob, this sheet is just for 1 month. For 12 months, you will have to create 12 sheets. Just by changing the month from the dropdown, data is not going to change or erased
For you it might be useless but I find it very useful, when I create duplicate sheet of next month, I don't have to type the months name and it saves me from spelling mistakes too. Just a simple spelling mistake and format will be useless as all the dates, days and holidays are inter connected. Even by mistake nothing can be inserted where I have used dropdowns. So if something is useful for me may be useless for you and vice versa. In case you want to delete the data of previous month, then you will have to use Macros. No other option till date, to my best of knowledge
Nice..... I make it
Wow. That's really great. Happy for you
There is a problem, if you can help me, when we change the month, the old data remains. How can I make the data (P, A etc.) adapt to the selected month?
Create a video on month wise attendance summary
Hi Amit,
I have got more than 10 Attendance Sheets on my Channel and most of them are Monthly waise. You can check once
Please advise whenever the 2nd and 4th Saturday are holiday. Which formula applying for said position.
Instead of putting any formula, put the list of 2nd and 4th Saturday in Holidays
If not, then it will be mix and match of Formulas ans conditional formatting
Hallo sir I asked attendance sheet automatically updated through bio matric data
You will have to mail me the format which gets downloaded from Biometrics. Based on that I can create a format. So that you will have to copy paste the Biometrics data in Excel format and all the components will be calculated
In Excel, if we move one heading below one heading in ABC row, the size of two headings changes. If you move the ABC row, the size of the heading at the top should remain the same. The heading below should be resized and changed. Tell me how to do this.
Your qs is not clear to me. Plz provide me all the details
Hi , Vijay
How to calculate difference value between two no#, like there are only positive value and negative values.
Ex: 5300-5200=100 ,which is 100 deficit
5200-5300 =-100, which is 100 surplus, can you please help out ..any formula for large data ..
Hi Harish, I haven't got your point. Can you please mail me the example file.
Hi, How to count everyday present , absent etc separately. TIA for help.
You can use COUNTIF
Based on this attendance data upload a new video in which we can caculate weekly working hrs, weekly negative and excess hrs,
Sure. I will try to create one. Thank you for you comment 😊😊😊
i've create the sheet completely. However, when i choose February, the column data for date 30,31 from January still appear. Please advise what should do ?
Please send me the formula of 2nd date
And chenge month vanish all details last month data
How can i merge 12 months attendance in 1 sheet..
Please watch my latest video of Attendance Sheet. I have managed all the months in a single sheet
The date 30 and 31 when I select something it won't be counted
Haven't got your point Sir. Can you please elaborate
@@Office-Monk when I select CL or P or A on date 30 and 31 of the month it won't be counted in the P or A cell no 1 will be display
Some on edited the formulas on line. I changed it back. Now you can check it. Now It's picking up all the things properly
@@Office-Monk It's still the same sir. Date 30 and 31 if I select Present it won't add 1 in Present Row
Mail me the file please.
vijaymuukh@gmail.com
I've become a member but I can't download the file. I've paid for it right away. Only for viewing.
Drop me a mail and name of the formats you want to download
I still haven't got your mail. Please drop me a mail and I will share the file
@@Office-Monk Hi, I sent you an email. Thank you for looking into this.
Hi,
Please check your mail. I have shared the link. In case you are not able to see my mail, please check your spam folder once. Thanks a lot for joining the Channel Membership.
Hi, hope you got the formats what you were looking for. It's not a scam. Files online have got only the option of view. I send the formats to Channel Members through mail. So it's not any type of scam. If you haven't received the formats yet, please drop me a mail
There is a problem, if you can help me, when we change the month, the old data remains. How can I make the data (P, A etc.) adapt to the selected month?
Hi Bob, this sheet is just for 1 month. For 12 months, you will have to create 12 sheets. Just by changing the month from the dropdown, data is not going to change or erased
Hai sir
Please display large size when you are creating formulas
@anandakumar8013 sure
For you it might be useless but I find it very useful, when I create duplicate sheet of next month, I don't have to type the months name and it saves me from spelling mistakes too. Just a simple spelling mistake and format will be useless as all the dates, days and holidays are inter connected. Even by mistake nothing can be inserted where I have used dropdowns. So if something is useful for me may be useless for you and vice versa. In case you want to delete the data of previous month, then you will have to use Macros. No other option till date, to my best of knowledge