How to make attendance chart for employees in Excel
How to track vacation. How to track sick time. How to track sick time.
How to track leave. Email me if you would like a copy of this file
Allow me teach you the skills in Excel that you need for business
Let me teach you the VBA that I have learn in my five years of consulting
Become an Affiliate and earn 25% on Course Sales
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Barb, I love this calendar I have it all set up and working but only for one month. how can create the rest of the months and type in on the following month without affecting the original? thanks for your help on the is.
Plz some suggestion, I cannot select the months
How do I get Late (L) highlighted if they arrive to work after 710am or 340pm The working day day is 7am-3pm and 330pm-1130pm ?
This video is not like & subscribe me
Please, what do you do after write the January? as my one is not working. Great job
I think I missed how you were able to do the same thing for the 1’s….w/o having to do it all over again…
This was very helpful🙌🏽
Hello Barb,
Thank you for this video which I find inspiring and informative. How would I go about calculating the leave period in hours? Let's say that someone takes 3 hours of vacation on Tuesday the 3rd of year xxxx, how would I go about calculating the totals? I would be grateful for any pointers you may give. Thank you in advance!
Thank you so much this was very helpful. How do I continue with adding additional months?
Hi, thank you so much for this 🙏
but i still need a help plzz !
I'm looking for a way to make the count changes automatically when i scroll between months from the name box. for exemple, at june, the employee has 2 (sick), that he has 3 at september
hope u can understand what i need 💟
Hi Barb, Thank you for the video. Very helpful. I followed you through the whole video, except I could not figure out how you had the drop down for the months. I did not have the drop down on mine. Can you please suggest or tell me what I am doing wrong.
Can i please ask how i can make it so that the Sick time is counted as hours instead of a full day? That way there are some sick hours left over for the year that still can be used. in other words, how do i track by hours rather than days? thank you!
I’m having trouble how you grey’d out the 1’s @ 5:44 into the video. Your mouse moved off the screen and couldn’t see what you pressed 🤔
hi Ms. Barb
i need help, how can i make this but with a formula that allows employees to get 36 days in a cycle of 3 years?
"What we're gonna do" is get better at Excel thanks to you! Great job!
Hi Barb. Thank you for your video. I have been looking to create a tracker to track the paid time and sick time for my 25 employees. I am not trained in excel but I use it sometimes. What I have been trying to learn to create is how can I make this sheet automated. so as the months go on I am able to replicate it with automation. and this way if I need to go back to it I have it at my fingertips. especially to track the sick time. I noticed that in this video you only put the conditional formating in the first line to check for V or S day. Do you copy it to the rest of the employee lines?
Also, Would it be possible if I can get a copy of your file? Maybe I can just use yours and would not have to create one on my own.
I also was checking out your other video for the yearly tracker and I am also interested in a video in your library to keep track of the employee certificates. they all seem very helpful. thank you for sharing your knowledge.
I love you mam thanks for appreciate 😘
I just created my January tracker. How do I go about creating all the other months? Do I have to do the same thing for each month?
Barb, could help advice pls
On 1( Sunday) collumn d not showing Grey color line like other which related (7)
subscribed
Barb,
Good video–I struggled, though I eventually figured it out. I'm one of those very highly and dependent kinesthetic and visual learners @ around 8:30 trying to replicate your "count if" function for totals and still wasn't sure how you were doing what you were doing beyond the typing. With the range, I had initial trouble highlighting my preferred rows and then making the dashed lines around them become solid. Then I got very frustrated in making the criteria function work–I could never get the word "criteria" to click ("range" would still be highlighted). I finally had to do what you did and click the function button to get it to pull up)
So far, your video is the best I've seen, esp. in solving my problem in having my total or sum column by names rather than the very end (I tried AutoSum and the sum function without success)–I'm tracking student absences ("X" for absence, blank if here) for the semester and the rows get VERY long. Easier to see the total next to the student's name for final grading rather than horizontally scroooooolling way over to the opposite end of the row (AutoSum puts it here at the opposite end very inconveniently).
I figured this out via another YouTube video from long ago but forgot and wasn't able to figure it again, now–so I'll try to remember this and hope your video sticks around. Thank you!
HOW TO MAKE DUTY ROSTER FOR TEN EMPLOYEE FOR DAY /NIGHT
I'm following your steps accurately to apply conditional formatting to block out non-working days; however, only the first row has the formatting apply even though I've selected the entire range of cells for the month. Any ideas on why this is the case?
This was extremely helpful and I am in mankato in a MIS class
Thank you Ms. Barb, the video was very helpful.
Hello Ms. Barb Henderson, could you tell me how to separate the month because I watched your video and I followed you, but it doesn't work?
If an employee drops in September… How we maintain him in previous and later months?
Is employees'list different in every month or same?
how to change months and date????
Been looking for instructions on how to use "s" and "v" key (conditioning) and couldn't find
anywhere!! Thanks so much!!! I've subscribed!!! Brill vid!
You’re a genius!
thank you Ms. Barb it's really easy and tricky i like the idea