Calculating Sick Days for New Employees

[eromadm]

I have employees hired different months of the year and I have to calculate their sick time from date of hire. For existing employees the formula we use to calculate 1/2 day for sick time each month and the formula that I use is: =month(today())/2 for year beginning in January. When I have an employee starting in other months what formula do I use to calculate 1/2 days from start of employment. Example I have employee starting in September what formula do I use.

 

[rikvny02]

If the new employee starts in the middle of the month do they still accrue the full 1/2 day

 

[Joe4]

When do they actually "accrue" the half-day, at the end of each month, or on the anniversary of their hire date?

 

[eromadm]

If the new employee starts in the middle of the month do they still accrue the full 1/2 day

No it is accrued at the end of the month. Not based on date of hire

 

[eromadm]

Yes but it is accrued at the end of the month

 

[Joe4]

No it is accrued at the end of the month. Not based on date of hire

So, are you saying that the will only receive the accrual if they are there for the full month?

What if they were hired on the first day of the month?
Would they receive an accrual for that month?

 

[eromadm]

So, are you saying that the will only receive the accrual if they are there for the full month?

What if they were hired on the first day of the month?
Would they receive an accrual for that month?

Yes, they would accrue the day at the end of the month not the beginning.

 

[Joe4]

So, you only answered one of the first question in that quote, and not the others...

 

[eromadm]

Ssorry,

So, you only answered one of the first question in that quote, and not the others...

Is there a formula to calculate days when they start in the middle of the year? The formula that I use is =month(today(()/2

 

[Joe4]

Yes, but we need to know the exact rules/criteria, which is what I am try to get from you!

You included my second question in your quote, but never answered it:

What if they were hired on the first day of the month?
Would they receive an accrual for that month?

If you would like my help, please answer that question, as that has a big impact on how we write the formula!