Create a Yearly leave tracker for Employees

[@BarbHendersonconsulting]

Thank you so much for watching my video. If you have any suggestions for future video topics please leave them in the comments below

[@himansuprasaddongri3843]

thanks barb

[@ilovenick907]

I am complelty excel illiterate, and even though this took me a few tries, I was able to format everything exactly. Thank you so much! My bosses will think I'm an excel genius and it's all because of you.

[@BarbHendersonconsulting]

Excellent!

[@jenibajar6030]

Thank you Barb. Just saw your videos recently. Your videos are like having an instructor sitting beside me. Very helpful, very educational. Thank you hope you will not get tired of sharing your skills and knowledge to all of us.

[@BarbHendersonconsulting]

I guess that years of teaching software classes is coming out! Thanks

[@idacardenas5610]

This was amazing! I have such a tough time using excel because I do not use it daily, but your instructions were very easy to follow. Please continue to share your skills and thank you! :)

[@BarbHendersonconsulting]

Glad it was helpful!

[@ArwenBlackery]

Hi, this has been a great video and helped me set up a matrix, however, how would you show if someone is having a half day sick or annual leave?

[@BarbHendersonconsulting]

check out this video kzbin.info/www/bejne/pYGYipKpfLh_adk

[@I.am.human26]

Very helpful, the only difference is teh variations in the function between and excel sheet and google sheet. Struggled with conditional formating google sheet.

[@BarbHendersonconsulting]

good luck

[@friendlypestsolutions9489]

Great Spreadsheet. Very helpful. What is the Bank column used for?

[@BarbHendersonconsulting]

This would be for the days that they were absent that are not sick or vacation.

[@malcolmneate5852]

This is so cool. Great explanation. I’ve just made a replica of your rota. My bosses are blown away. Thanks!!

[@BarbHendersonconsulting]

Fantastic!

[@malcolmneate5852]

@@BarbHendersonconsulting who’d a thought I knew excel so well……….

[@ruchibansal1237]

This video is awesome and very well explained! Thank you so much!

[@BarbHendersonconsulting]

Glad you enjoyed it!

[@janbns]

Thank you. How can we add the days (Monday, Tuesday, etc…) above or below corresponding to the dates?

[@BarbHendersonconsulting]

add another line and display the dates. Then select the cells and select format and go to custom....enter ddd

[@d4rk1sh3r3]

How can i add two buttons and view 31 days per month? This format but in a calendar mode. Remove freeze rows and columns. Just to buttons prev. next to switch months and keep x and o from this sheet. Thank you

[@BarbHendersonconsulting]

You would have to copy the separate months to other sheets and keep the whole year to maintain your totals

[@lwc41]

How do you writte downwards on the VAC, SICK, BANK cellS?

[@BarbHendersonconsulting]

On the home tab, select alignment or right click and select format cell and select alignment

[@maryapolot4754]

I don't know why but When I enter the letter, it automatically adds the number to the next employee. How can I fix that?

[@BarbHendersonconsulting]

Check your steps, it should not do that

[@Mitul2008]

Thanks! This was really helpful 👏

[@BarbHendersonconsulting]

Glad it was helpful!

[@shaik4122]

Thanks a lot!!! But I still don't understand on how to disable rest days/off days from the tracker.

[@kholoud8872]

This is great, and easy to follow. Thank you so much. :-)

[@BarbHendersonconsulting]

You're very welcome!

[@jasminrojiya1982]

what if i want to grey out only the 2nd and 4rth saturday and all sundays

[@BarbHendersonconsulting]

I do not believe that you could gray out every second Saturday without code

[@GarciaonlyJesus]

Wait if 7 is for gray Saturday what will be Sunday? Thank you

[@BarbHendersonconsulting]

sunday is 1

[@frauleinmaghuyop5442]

Hi! Can you help me how to do this that accepts half day?

[@BarbHendersonconsulting]

See my reply to the other comment

[@oluchipamelaukwuegbu9470]

Hi, pls how did you add the Sundays check clip 5:00

[@BarbHendersonconsulting]

follow the same steps, Saturday is day number is 7 and Sundays day number is 1

[@rebeccawoodward1661]

This is awesome!! Thank you so much for sharing.

[@ismaeldembele6962]

Thanks for the very helpful video, for example as for 4 weeks in (working) and 2 weeks of (on break) so how can we deal with this can situation on excel????? Thanks in advance!!!!

[@BarbHendersonconsulting]

I think this is the video you need to look at kzbin.info/www/bejne/b4W9fX2Gg8h9f6c I originally created this for an organization with similar needs to yours. It would be easy to change the code to reflect your needs.

[@pradipjha2491]

Lovely video…. Have a query… How to automatically calculate between Leaves already Availed & leaves planned for future dates…

[@BarbHendersonconsulting]

If you enter plan leave a head of time it will display what is remaining

[@jeyubobo]

this method is unable to count half day leave

[@BarbHendersonconsulting]

if you change the time to hours instead of days then it will work

[@Xwoman07]

How can i do that every time the letter L the is color green

[@BarbHendersonconsulting]

Conditional format for the schedule

[@mariabartolo1323]

Thanks for the very good idea… 💕

[@BarbHendersonconsulting]

You are so welcome!

[@sagarikaoceania]

Thank you very much for this tutorial.

[@dontrimp1664]

Confusing

[@BarbHendersonconsulting]

Sorry, try watching it in stages

[@ahmadbchennaty123]

I really like it is very simple and easy

[@BarbHendersonconsulting]

Glad you like it!

[@keeratikornkarnbudprom9740]

Thank you so much

[@BarbHendersonconsulting]

You're most welcome

[@ashoksahu9546]

Thank you so much. Very nice video.

[@robertgregoriojr.9891]

what if half a day? what function?

[@BarbHendersonconsulting]

if you need to enter part -days then I would enter hours instead of days. If they get 7 sick days a year and they work 8 hours then they would be allow to to have 56 sick hours a year

[@robertgregoriojr.9891]

Barb Henderson sorry i can’t get it, please can you demonstrate to me thru videos? coz i have difficulties on how to create functions with regards on the leave usage (half-day only). By the way, we have 15 days earned leave each for the sick & vacation every year. i hope you can help me with this, thank much in advance🙂

[@robertgregoriojr.9891]

Barb Henderson please😔

[@BarbHendersonconsulting]

@@robertgregoriojr.9891 I already have my video for this Sunday, I will create something for next Sunday

[@BarbHendersonconsulting]

Here you go Robert kzbin.info/www/bejne/pYGYipKpfLh_adk

[@andrewsalim1785]

brilliant!

[@BarbHendersonconsulting]

thanks

[@Xwoman07]

Thank you very much

[@BarbHendersonconsulting]

You are welcome