Hi all, looking for some help in coming up with a formula that will display a duration in decimal month spread over a calendar format.

So for example if the start date is 01 Jan 2020 and the end date is 15 Apr 2020, I want the result to show :

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1 1 1 0.5 0 0 0 0 0 0 0 0


I've dabbled with MONTH and IF and come up with either a formula that returns the duration in one number (3.5) or another that just marks each month with a 1 if the end date is greater or equal to 1 for Jan, 2 for Feb etc. The latter is closer to what I need but only works if there are full months, any idea how I can get results as shown in the example above?

Thanks!