Holiday entitlement calculator formulas

S

snowdrop1

banned
Joined
Jun 8, 2010
Messages
118
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!>>!>
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Sort by date Sort by votes
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
 
Upvote 0
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
BCDEFGH
8Start date
925/03/2010
10Hol Year startHol Yr EndAccrual Start DateTodayDays in ServiceAccruedMax amount
1101/01/201031/12/201025/03/201029/09/201018812.9125
Sheet1
Excel Workbook
D
1125/03/2010
Sheet1
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Subtracting all calendar days, but end date cannot fall on a weekend or holiday. If it does, the end date shifts to the preceding work day.
Replies
8
Views
431
Romy
R
B
  • Solved
Projecting End date by accounting for holidays
Replies
4
Views
351
BB77
B
E
  • Solved
How to use WORKDAY to calculate the Final Training Day and exclude Weekends and Public Holidays
Replies
5
Views
358
Fluff
Fluff
B
  • Solved
Annual Leave Entitlement forumla
2
Replies
19
Views
1K
Georgiboy
Georgiboy
W
  • Question
Holiday hours Calculation
Replies
2
Views
452
Wrenn_6869
W

Forum statistics

Threads
1,216,099
Messages
6,128,822
Members
449,470
Latest member
Subhash Chand

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top