we are going to talk about calculating vacation

entitlement from the excel sheet on our sheet here we have listed a number of

employee numbers here and there start date they earn your point five eight

three days per month when they’re working they have to work for too months

before you’re eligible for any vacation so the first thing that we’re going to

do here is calculate when they are eligible for their vacation so what

we’re going to do with use the end function works in that you go equals edate

and then your your start date and then put a comma and it has to be two months

so that would be your end date now you press enter so that is you end date for when this individual is available to

have holiday so it’s dragged down for now calculate how much how much vacation

these people are all entitled to do so and then we’re go equals if and then we are going to say if this date is less

then today which will bring up today’s date then what we are going to do is take the month from today’s date minus the month from the end date their start date and we are going to times it by this number here which is the amount of holidays they acquire in one month so lets click on that and absolutely reference that so lets click on the F4 key on our keyboard and then we will put a zero here now we need to count up our brackets and press enter so there you have the number of days of vacation that they have earned

straight to the point and helpful! how can I do this same thing, but with 4 hours BI WEEKLY? thank yoU!!!

How do i calculate the vacation days if per yr, we're given additional one day, capping at 14days a yr?

Madam, how can I apply this formula for different years? If I joined in May 2017, how can I know my accrued leaves till date considering vacation is allowed only after completing work contract of 18 months or 24 months?

Thanks

Madam, your tutorial was very helpful and everything was going fine till we stepped into 2019. Now all the accrued leaves have turned negative and are giving me incorrect days. Can I email you my spreadsheet?

Awaiting your response. Thank you

Your tutorial was extremely informative and helpful. I was wondering if you can explain how to input New Hire vacation when it depends on what day of month you started on. For example if I started on February 22, then on March 1st I would have .5 days sick time available. Thank you in advance.

Days 1-8 accrue 1 day of sick time

Days 9-23 accrue .5 days of sick time

Dates 24-31 accrue no sick time

Hello very helpful. How would I calculate 3 days per 30 days worked accrual starts on day 1 has a limit of 14 days? Thank you!