Holiday entitlement calculator formulas

[snowdrop1]

hello i need to set up a quick holiday calculator tool, but i am rubbish with formulas..
i have just 2 elements...

cell a1...will be holiday entitlement.. ie..10 days..15 days 25 days or any day value.. ( entitlement is caluclated by full year 25days/ less start date!>>

cell a2 will be start date...

the holiday year starts on 1st jan of each year..

so what is to calulcate the accrued holidays asat 2days date..?

i guess the formula would be holiday entitlement divided by start date minus start of year? = accrued holidays??

i did say i was rubbish...

can you help!>>!>

 

[JackDanIce]

If start date is 2nd Feb, then total number of days since year start is 33

So holiday entitlement would be 33/365 x 25

 

[scottylad2]

D11 determines whether your count is from start date, or 1 january

I'm assumng an allocation of some holiday amount for each days employment up to a max of 25 per year

Excel Workbook
	B	C	D	E	F	G	H
8			Start date
9			25/03/2010
10	Hol Year start	Hol Yr End	Accrual Start Date	Today	Days in Service	Accrued	Max amount
11	01/01/2010	31/12/2010	25/03/2010	29/09/2010	188	12.91	25
Sheet1

Excel Workbook
	D
11	25/03/2010
Sheet1

 

[Canigroup]

HI,

I was looking through the internet and found your post about Holiday Entitlement. I have make a copy of your Excel document but dont really understand why it is not working.

Was wondering if you could help me as am not very good with excel but really this document would help my business alot.

I was wondering how " Days in Service " Works as i think this is why mine isnt working. I have done all the other Formulas right but still not working.

Can you help please.

 

[scottylad2]

Caouls you explain your requirement? at what rate does your holiday entitlements acrue and what is the max in a year? whats the year start and end points for the accrual?