Days to be paid at different rates

IRate change.xls[I]
If Birthday falls between start and end dates, new rates apply, formula to calculate days at each rate.....please

Try Entering a birthday like 01/10/08 and you'll see why it fails

Pat

All days. a straight change of rate if your birthday falls between start and end dates(inclusive) Thanks

---------- Post added at 11:29 AM ---------- Previous post was at 11:24 AM ----------

Number of days only i.e 32 days rate 1 26 days rate 2. Year of birth is the problem. It's not a simple subtraction of dates

Thanks for your help.....now sorted with Datedif using the "YD" function which ignores the year part of the DOB field

Thanks

Pat