Creating a formula to populate range of cells between dates based on start and end dates

Hi All,

A contributor was able to help me with the first part of this formula. However, I noticed the formula doesn't work on a date range beyond 12 months.

I've re-posted this thread with the hope that I can get an answer to the second part:

If you refer to the attached excel file you will notice the Project Manager profile is working from the 01/01/2015 to the 28/02/16. The formula in cell F6 however only identifies the months and not years. So rather than equaling 1 year and 2 months it calculates to 2 months. Likewise the formula in cell range G6:V6 doesn't work on a date range of greater than 12 months (highlighted in yellow).

Can someone help/show me how I can get the formula to work beyond 12 months?

Many thanks!
Remon

Use datedif() function
easy and simple...

check the attachment



Don't forget to click *, if it helps you someway...

Hi Vikas,

Thanks for your reply. What about the formula in cell range G6:V6? This is the one I really want updating. I want the cell range to be populated based on the date date range in column D and E. However, at the moment, it only works for 12 months.

Thanks,
Remon

Hi martindwilson,

Thanks for your reply. What about the formula in cell range G6:V6? This is the one I really want updating. I want the cell range to be populated based on the date date range in column D and E. However, at the moment, it only works for 12 months.

Thanks,
Remon

Hi martindwilson,

Thanks very much - that works perfectly well now. Looking at the formula now it looks so simple!

Many thanks,
Remon