Building a Budget Spreadsheet

[baileygirl41]

Hey! Please help, I am working on a personal budget spreadsheet. I have a table with the months and their respective days, e.g. September; 30; March; 31. I have made the headline a dropdown list from this table where you can select the month.

What I need to do is:

There is a piece of my budget that breaks my disposable income into daily amounts that compound as I do not spend money. Obviously this amount/day depends on the total days in the month. So in my "budget/day" box I want to build an if statement that is like "if the headline says october, divide total disposable income by the number next to October in the table, i.e. 31" "if the headline says March, divide the total disposable income by the number next to March in the table, i.e. 31" etc.

I am naturally an over explainer, and I have been trying to google this for an hour so I want to make sure I am super clear on what formula I am trying to build. Can anyone help?

 

[Snakehips]

@baileygirl41 Welcome
It's difficult not knowing your data layout but, maybe similar to the following will help?

Book1
	A	B	C	D	E	F
1	Year	2022			Disposable
2	Month	Days		Monthly	$500.00
3	January	31
4	February	28			June
5	March	31		Daily	$16.67
6	April	30
7	May	31
8	June	30
9	July	31
10	August	31
11	September	30
12	October	31
13	November	30
14	December	31
Sheet3

Cell Formulas
Range	Formula
E5	E5	=E2/XLOOKUP(E4,A3:A14,B3:B14)
B3:B14	B3	=DAY(EOMONTH("1/1/"&$B$1,ROWS(A$3:A3)-1))

Cells with Data Validation
Cell	Allow	Criteria
E4	List	=$A$2:$A$14

NB in the table for the dropdown months I have used a formula that will adjust February days for leap years
.