Formula dependant on month/date

R

Ravi Sandhu

Hi guys

I hope you can help with this.

I need to make some formulas in Excel, relating to holiday entitlement.

if one of my employees has worked less than 1 year, then they receive 30
days holiday entitlement

If they have worked more than 1 year, they receive 31days holiday
entitlement

2 years, and 32 days holiday entitlement , etc.

I need to create a 4th column which tells me how much holiday entitlement
Danielle Sholbread has left.

I hope someone can help

Thanks


Name Days absent Start date
Danielle sholbread 8 12/04/2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating Sick pay entitlement 2
Urgent help with formula(s) needed, pls! 0
number of months and days between two dates without approximation 3
Formula to count occurences of sickness 1
Calculate Complete Months Between Two Dates 15
easy udf by VB 1
problem with time subtraction 7
Adding days to the WORKDAY function 2

Top