Month-to-date calculator for a budgeting app on Google Sheets

[joshgun]

Hey everyone,

I am making a small personal budgeting sheet and am stuck now and need your help.

So, I want to write a function that takes today's date (14th of August, for example) and compares it with my spending from the previous month's spending.


Thank you so much in advance, I've been thinking of it for almost 3 hours!

Please check a sample that I created from the sheet below:

[Pete_UK]

It is not a good idea to use merged cells for the dates. As today isn't really 4th August, I have put that date in cell R3 - you could subsequently put =TODAY() in that cell.

You must also have the next date in columns B and G, i.e. 8th June in B30 and 8th July in G30, and then you can use these formulae in the cells stated:

S14: =SUM(D$5:INDEX(D$5:D$30,MATCH(DATE(2022,6,DAY($R$3)+1),B$5:B$30,0)-1))

S15: =SUM(I$5:INDEX(I$5:I$30,MATCH(DATE(2022,7,DAY($R$3)+1),G$5:G$30,0)-1))

S16: =SUM(N$5:INDEX(N$5:N$30,MATCH($R$3+1,L$5:L$30,0)-1))

These will SUM the values from row 5 up to the date specified in R3 for the appropriate month, although your layout does not make it very easy to cope with future months.

Hope this helps.

Pete

[joshgun]

Wow! Thanks, man, I really appreciate it.

You deserve Excel Guru title, for sure, lol.
The real document is different - I made a simple one for this forum to ask my question.

Have a blessed day!

[josephteh]

With the dates filled up in each row in columns B, G and L,
S14 =SUMIFS(D:D,B:B,"<="&DATE(YEAR(B5),MONTH(B5),DAY(TODAY())))
S15 =SUMIFS(I:I,G:G,"<="&DATE(YEAR(G5),MONTH(G5),DAY(TODAY())))
S16 =SUMIFS(N:N,L:L,"<="&DATE(YEAR(L5),MONTH(L5),DAY(TODAY())))

[joshgun]

I have modified it to my original document, and it's working too! Thank you, Joseph