Excellent video. In our organisation we are allowed to take half a day leave. I will try to recreate this sheet with an option to mark H . Thanks a lot
Thank you! However, in the template, when I change the month, the drop-down button and total attendance remain the same. If possible, I would like the flexibility to customize the drop-down button and total attendance for each month. I would prefer that when changing the month, the drop-down button reverts to its original format, allowing me to customize it anew for each month. Essentially, I want the template to be adaptable and allow for customization of the drop-down button and total attendance every month. Is that possible? Can you make another tutorial? Appreciate it.
well made template , was very useful and added some of uour logic in my version as well. i was trying to find certain calculations like how many people are off on friday/monday/ leaves etc, do you have any suggestions how to acheiev this ?
Hi! Present and Leave Tabs are Working where numbers are counted but in Absent tab there showed 0 values and nothing changed! Please guide a bit why this is happening
what if i want to add leave entitilement sick leave,emergency leave,mission,annual leave.how to fomulate that? Thank you.i look like easy for me that excel.more power
Hi, Your teaching is very much useful. Thanks for the video... But i was trying to add some more options like half day leave and timings of login and logout.. i ended up in confusion.
Wonderful approach sir. But one thing I want to know that how to create dashboard of whole year of all the employee. And also want to know how filter any employee with month wise attendance report.
I have started practicing this. But the formula is not working. I tried multiple times and it still shows 0 in the box of Present. Though i selected the present on two dates. Can you help me to recover this?
I need to clear the cell data on the google sheet when switching from the current month to the next months on the attendance sheet, however the prior months data should be remembered. How to do ?
when you changed the month to October in the end. The Present and absent did not updated to default. Entire lecture of no use, just because of that one mistake.
It's all useless, when you fill the entire sheet for a month and then port it to the next month you will again be back to the previously filled sheet, only the date and month will change.
Thank you, Uncle!!!! I was able to create a working attendance sheet for the first time ever!!!
Most welcome
Thank you SO much!! This has been soooo helpful! I'm an HR Asst and looking for new ways to organize our data and this is PERFECT!
Thanks for your valuable feedback
THANK YOU THANK YOU....JUST NOW I WAS CONFUSED THIS VIDEO REALLY HELPED A LOT JUST PERFECT
Most welcome
Helpful information 👍👌👌👌
Thanks🙏
Excellent video. In our organisation we are allowed to take half a day leave. I will try to recreate this sheet with an option to mark H . Thanks a lot
Most welcome🙏
Best tutor ever. Thank you
Most welcome
absolutely Knowledgeable content, thankyou so much
Most welcome
Thank you! However, in the template, when I change the month, the drop-down button and total attendance remain the same. If possible, I would like the flexibility to customize the drop-down button and total attendance for each month. I would prefer that when changing the month, the drop-down button reverts to its original format, allowing me to customize it anew for each month. Essentially, I want the template to be adaptable and allow for customization of the drop-down button and total attendance every month. Is that possible? Can you make another tutorial? Appreciate it.
well made template , was very useful and added some of uour logic in my version as well. i was trying to find certain calculations like how many people are off on friday/monday/ leaves etc, do you have any suggestions how to acheiev this ?
Very Informative and i did complete by following the steps however there is one issue if you could help on this
Excellent
Thanks
When we are changing the month we are not getting a fresh sheet but with previous month data on the next month
Thank you for this!
My pleasure!
if we are entering data for the next month, data is getting replaced in the original month as well.. how to keep all the months' data stored?
Hi good teaching to make google sheet on attendance
Hey PK, nice video
Thanks
Thanks Brother
Welcome
Hi! Present and Leave Tabs are Working where numbers are counted but in Absent tab there showed 0 values and nothing changed! Please guide a bit why this is happening
fx = 0 in my google sheet how i can fix it ?
what if i want to add leave entitilement sick leave,emergency leave,mission,annual leave.how to fomulate that?
Thank you.i look like easy for me that excel.more power
Please share template link it will be helpful for us🙏. Btw it's a very informative video.
Template link has been given in videos description box
Hi, Your teaching is very much useful. Thanks for the video...
But i was trying to add some more options like half day leave and timings of login and logout.. i ended up in confusion.
I will try to create a separate video on this topic
why the number format is not working in my speadsheet? what should i do
I am not satisfied, how we can update the weekly off and holiday in every month??????
Hello! Thank you for this! May I have permission to use your template for public use?
Respected,
Dropdown Option is not showing in office 365 online
After changing month previous attendence data is not changing. Still it's been displaying. Please suggest.
You need to manually remove the old attendance data.
@@NeotechNavigatorshow do you do that? Can you assist? Thank you
hello brother, if we go to the next month to mark attendence it is already showing the previous month attendence
yeh fake tutorial
why present absent not updating to default ?
Nice work it will be helpful if you add the template link
Thanks.. will add
thank youuuu
This template Download link plz🙏🙏🙏
how to get the total present/absent per day? it only shows the info per employee
Very informative and I don't see any change in the data when you go for the next month. It would be helpful if you let us know. Thanks
For the next month we have same inventory
How can we add attendance percentage
Sir, when I am creating the drop-down, the text is not visible, font size is 8-9-5-4, I have tried everything...plz help
Thank you can you add the tempalte link on description, it will be helpful
Template link is in the description box
@@NeotechNavigators Thank you for the video! It appears that I cannot see the link in the description box. Is it only visible to few people?
Wonderful approach sir. But one thing I want to know that how to create dashboard of whole year of all the employee. And also want to know how filter any employee with month wise attendance report.
Thanks for your valuable feedback. I will try to add in next version.
I have started practicing this. But the formula is not working. I tried multiple times and it still shows 0 in the box of Present. Though i selected the present on two dates. Can you help me to recover this?
wher is the template i cant find it in te descprtion
Template link has been given in videos description box or visit our website www.NeoTechNavigators.com
Sir the count if formula is not getting applied. Pls help.
I need to clear the cell data on the google sheet when switching from the current month to the next months on the attendance sheet, however the prior months data should be remembered. How to do ?
Will create this in next version.
How do you calculate the percentage?
You can check the formula in the template. Link is given description box.
How to filter absent name list ?
This is only good for one month. Once you change the month, the present and absences is still showing and not getting back to empty default.
But when i am dragging the dates… it is not working
You should consider freezing the name so when you're scrolling to the far right the names will be aligned with their attendance.
great suggestion!
kindly grant me access...
Drop-down ko kaise change karen month wise isska koi video banna do 🙈
Will try explain in the next version of it
How to store the data like May month April month june month Can u please can me how to store
How do we unselect data selected
Just put False in one cell then copy to all
@@NeotechNavigators thank you
Magnifique tutoriel. Est ce possible de nous faire même sur Excel
muchas gracias
Dear sir
Tutorial is helpful but,request for the Hindi language
Noted
when you changed the month to October in the end. The Present and absent did not updated to default. Entire lecture of no use, just because of that one mistake.
Same issue have you got the solution if yes pls help
It's all useless, when you fill the entire sheet for a month and then port it to the next month you will again be back to the previously filled sheet, only the date and month will change.