Vacatio Accrual

[Guest]

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.

 

[Bob Phillips]

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

--
---
HTH

Bob

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

 

[Sandy Mann]

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

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

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.