Hello,
I am stuck on a formula to return (in seperate cells) the number of months and days between two dates. I've tried using DATEDIFF function but it's not giving me the correct number of days unless its a 30 day month. I need it to look at the actual number of days in that month i.e 28 for February.

To give some context I am working on a holiday allowance calculation for new employees. our holiday leave year is 1st april-31st March, 23 days leave. If someone starts on the 22nd October, we would calculate their holiday allowance as (23/12)*5)) + (23/365)*10)). 5 being the number of whole months Nov to March and 10 being the days in October between start on the 22nd and the end of the month on the 31st.

I would like just to be able to put the start date in and the leave year end date and to be able to get out an allowance, without me having to manually work out how many days there are between start date and end of the month each time.

Any ideas?
Thanks!