Vacatio Accrual
 

Hello,

I am in the process of creating a Vacation/Sick Accrual worksheet. I am
familiar with excel and yet I am having trouble with my formulas. No matter
what I keep getting an error in them. Employees accrue 10 days a year for
the first five years and 15 days a year after five years and they do not
start accruing unital after their first sixty days fo employment. I have to
calculate some of the employees all the way back to April of 2005. I hoping
to get some helpful formulas to calculate this.
--
Afroines

Vacatio Accrual
 

=IF(TODAY()-start_date<60,0,IF(YEAR(TODAY())-YEAR(start_date)+
((DATE(YEAR(TODAY()),MONTH(start_date),DAY(start_d ate))<=TODAY())*0.1)-
((DATE(YEAR(TODAY()),MONTH(start_date),DAY(start_d ate))TODAY())*0.1)<=5,10,15))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"AFroines" wrote in message
...
Hello,

I am in the process of creating a Vacation/Sick Accrual worksheet. I am
familiar with excel and yet I am having trouble with my formulas. No
matter
what I keep getting an error in them. Employees accrue 10 days a year for
the first five years and 15 days a year after five years and they do not
start accruing unital after their first sixty days fo employment. I have
to
calculate some of the employees all the way back to April of 2005. I
hoping
to get some helpful formulas to calculate this.
--
Afroines

Vacatio Accrual
 

Bob,

Perhaps I am missing something but surely

=IF(TODAY()-Start_date<60,0,IF(DATEDIF(Start_date,TODAY(),"y") =5,15,10))

Will return the same result. Or if the OP meant by

start accruing unital after their first sixty days fo employment.

That the years are counted from a date 60 days after the Start_Date then

=IF(TODAY()-Start_date<60,0,IF(DATEDIF(Start_date,TODAY()+60," y")=5,15,10))



--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Bob Phillips" wrote in message
...
=IF(TODAY()-start_date<60,0,IF(YEAR(TODAY())-YEAR(start_date)+
((DATE(YEAR(TODAY()),MONTH(start_date),DAY(start_d ate))<=TODAY())*0.1)-
((DATE(YEAR(TODAY()),MONTH(start_date),DAY(start_d ate))TODAY())*0.1)<=5,10,15))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"AFroines" wrote in message
...
Hello,

I am in the process of creating a Vacation/Sick Accrual worksheet. I am
familiar with excel and yet I am having trouble with my formulas. No
matter
what I keep getting an error in them. Employees accrue 10 days a year
for
the first five years and 15 days a year after five years and they do not
start accruing unital after their first sixty days fo employment. I have
to
calculate some of the employees all the way back to April of 2005. I
hoping
to get some helpful formulas to calculate this.
--
Afroines

Vacatio Accrual
 

Sandy,

Ok so just to clarify for myself in the formula you entered below I am meant
to reference the cell with the start date where Start_Date is?

I did try this and I am keep getting an error in the formula.
--
Afroines


"Sandy Mann" wrote:

Bob,

Perhaps I am missing something but surely

=IF(TODAY()-Start_date<60,0,IF(DATEDIF(Start_date,TODAY(),"y") =5,15,10))

Will return the same result. Or if the OP meant by

start accruing unital after their first sixty days fo employment.

That the years are counted from a date 60 days after the Start_Date then

=IF(TODAY()-Start_date<60,0,IF(DATEDIF(Start_date,TODAY()+60," y")=5,15,10))



--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Bob Phillips" wrote in message
...
=IF(TODAY()-start_date<60,0,IF(YEAR(TODAY())-YEAR(start_date)+
((DATE(YEAR(TODAY()),MONTH(start_date),DAY(start_d ate))<=TODAY())*0.1)-
((DATE(YEAR(TODAY()),MONTH(start_date),DAY(start_d ate))TODAY())*0.1)<=5,10,15))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"AFroines" wrote in message
...
Hello,

I am in the process of creating a Vacation/Sick Accrual worksheet. I am
familiar with excel and yet I am having trouble with my formulas. No
matter
what I keep getting an error in them. Employees accrue 10 days a year
for
the first five years and 15 days a year after five years and they do not
start accruing unital after their first sixty days fo employment. I have
to
calculate some of the employees all the way back to April of 2005. I
hoping
to get some helpful formulas to calculate this.
--
Afroines