Divide one number into multiple cells based on empty status

[martinogdenbsx]

Hi all

I'm wondering if you can help. I am using the =EOMONTH function to dynamically insert the number of months L>V based on cell F9 (Start Date) and G9 (number of months)

I want to divide cell E11 by the number of dates which show in L10>V10

In this example it would be £5790 / 2 [L10,M10) and put £2895 in L11 and M11 where the red arrows are

 

[Fluff]

Hi & welcome to MrExcel.
How about

=e11/sequence(,g9,g9,0)