Holiday Entitlements

Hi

I have a spreadsheet which works out how much holiday our staff are entitled to based on 28 days for someone working for us for 12 months, 5 days a week.

I worked out how to change the entitlement if they have worked less than 12 months, and if they work more or less than 5 days a week:

=((($B$1/12)*Q7)/5)*R7

where B1 is this years holiday (based on 12months service, 5 days per week), Q7 is months of service, and R7 is the number of days worked per week

But I have now been told that we cap the holidays at 28 days (so they don't get more days per year if they work a 6 day week).

I tried to make it so that if they worked 5+ days a week to show 28 days, other wise work out the days allowed, and my formula is wrong.

=IF(R7>=5, "28", ((($B$1/12)*Q7)/5)*R7)

What should I be putting?

Hi

The best way to describe your problem, is to attach a sample workbook

The only reason that (As i can see) that this formula does not works is this:

=IF(R7>=5, "28", ((($B$1/12)*Q7)/5)*R7)

Use the formula, like that.

=IF(R7>=5, 28, ((($B$1/12)*Q7)/5)*R7)


Hope to helps you