PPC budget calculator

Hello Martus and Welcome to Excel Forum.
Perhaps this will be a starting place. Using the table in columns K:N and the percentages in R10:R17
1) Type the first date of the month into K8,
2) K9 and down is populated using: =K8+1
3) L8 and down is populated using: =IF(MONTH(K8)=MONTH(K$8),TEXT(K8,"ddd"),"")
4) M8 and down is populated using: =INDEX(R$10:R$16,MATCH(L8,Q$10:Q$16,0))/COUNTIFS(L$8:L$38,L8)
5) N8 and down is populated using: =N$5*M8
Let us know if you have any questions.