K keanur Member Apr 19, 2023 #1 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 Attachments Budget 2023.xlsx 12.5 KB · Views: 11
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
A AVK Active Member Apr 19, 2023 #2 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 Attachments Budget 2023.xlsx 14.5 KB · Views: 8
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 Well-Known Member Apr 19, 2023 #3 Singel cell formula in H3: Code: =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.
Singel cell formula in H3: Code: =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.
K keanur Member Apr 20, 2023 #4 p45cal said: Singel cell formula in H3: Code: =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. Click to expand... Hi @p45cal tried to plug in the formula, however always has the error notif. Any suggestion? thanks
p45cal said: Singel cell formula in H3: Code: =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. Click to expand... Hi @p45cal tried to plug in the formula, however always has the error notif. Any suggestion? thanks
K keanur Member Apr 20, 2023 #5 AVK said: 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 Click to expand... Hi @AVK, Thanks for showing the way, I will use this formula
AVK said: 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 Click to expand... Hi @AVK, Thanks for showing the way, I will use this formula
