Splitting monthly budget figures to daily figures

[keanur]

Hi Excel Ninja,

I would like to know, how to split monthly budget to daily budget with dynamics number. I include actual numbers from year 2022 as reference and also the worksheet as a sample.

Thank you

Keanur

 

[AVK]

Need to calculate percentage of Qty v/s total qty of June 2022 See the column "O" & "P"
In "H3" =SUM($L$3*O3)/100
IN "I3" =SUM($M$3*P3)/100

 

[p45cal]

Singel cell formula in H3:

=LET(m,DAY(EOMONTH(G3,0)),SEQUENCE(m,,1,0)*CHOOSE({1,2},L3/m,M3))

This doesn't refer to the previous year's June figures, only splits the monthly budget into the number of days in the month.

 

[keanur]

Singel cell formula in H3:

=LET(m,DAY(EOMONTH(G3,0)),SEQUENCE(m,,1,0)*CHOOSE({1,2},L3/m,M3))

This doesn't refer to the previous year's June figures, only splits the monthly budget into the number of days in the month.

Hi @p45cal

tried to plug in the formula, however always has the error notif. Any suggestion?

thanks

 

[keanur]

Need to calculate percentage of Qty v/s total qty of June 2022 See the column "O" & "P"
In "H3" =SUM($L$3*O3)/100
IN "I3" =SUM($M$3*P3)/100

Hi @AVK,
Thanks for showing the way, I will use this formula