How to make attendance chart for employees in Excel



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

Rate this post

Bài viết liên quan

Theo dõi
Thông báo của
guest
32 Comments
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
Angel Blanco

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.

Mehm Soi Ha Chan

Plz some suggestion, I cannot select the months

Tenacious Taurus

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 ?

Abdul Kader

This video is not like & subscribe me

papaK

Please, what do you do after write the January? as my one is not working. Great job

Real Life Jalori

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…

Real Life Jalori

This was very helpful🙌🏽

KandhaiLoveWales

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!

Nova Cruz

Thank you so much this was very helpful. How do I continue with adding additional months?

Med Tayeb

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 💟

Akta Patel

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.

Nadine Krikorian

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!

Mando P83

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 🤔

Nkazimulo Langazana

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?

John-E C

"What we're gonna do" is get better at Excel thanks to you! Great job!

Jyoti Saini

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.

Ayub Khan

I love you mam thanks for appreciate 😘

Katherine Molloy

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?

Khim Seily

Barb, could help advice pls

Khim Seily

On 1( Sunday) collumn d not showing Grey color line like other which related (7)

Wafra Date Factory

subscribed

sail2byzantium

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!

solomon mogotsi

HOW TO MAKE DUTY ROSTER FOR TEN EMPLOYEE FOR DAY /NIGHT

Xavier Smith

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?

Kenneth White

This was extremely helpful and I am in mankato in a MIS class

Jennifer Brickly

Thank you Ms. Barb, the video was very helpful.

Chheng Chhong

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?

Thikana Takla

If an employee drops in September… How we maintain him in previous and later months?
Is employees'list different in every month or same?

Zaa Zaa

how to change months and date????

Candice Mcleod

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!

rock angel

You’re a genius!

Ismail Ismaili

thank you Ms. Barb it's really easy and tricky i like the idea