u/Working_Analyst_5136

Hi! I'm working on a budget spreadsheet and I'm trying to get the Payment Plans row to auto populate from a Payment Plans table so that the amount in the Budget is only equal to the amount due during a set month. Pictures to explain better:

These are the amounts and due dates of upcoming payments. One is in August and two are in September.

https://preview.redd.it/cb6ond1fayjh1.png?width=478&format=png&auto=webp&s=f9e070ca37e7da5c4d2fd33f63d62243f0e36189

This is the row in the Budget table where I want to add up only the amounts due during the set month. The amount in August should be -13.19 and the amount in September should be -26.38.

https://preview.redd.it/2hg1hl7qayjh1.png?width=813&format=png&auto=webp&s=c20debe626f00d86cb09e1189b4597127bef63a4

How do I set up the function to draw totals only from the corresponding months?

Thanks!

Hi! I'm working on making an academic year calendar and I want to set it up so that the current date is indicated by a highlighted cell. This is a snippet of what I'm currently working with:

https://preview.redd.it/gda4ee72m89h1.png?width=1440&format=png&auto=webp&s=44549dadc4c5cc481ca7b71886d43ee25a938867

Dates are listed 1-31 in the A column, with months across the top in row 2 and the current year in row 1. This is what I'm looking to achieve:

https://preview.redd.it/di5jonvem89h1.png?width=1444&format=png&auto=webp&s=46c805d32d96b50f5f02254a0c61ec95468244e8

So if the current date is June 7th, those two cells will be highlighted like the above.

I'm thinking I'll need a formula-based conditional formatting rule using =TODAY(), but I don't want to fill every cell with text showing the corresponding date. How can I make it so each cell is recognized as corresponding to the correct date so the conditional formatting will apply?

Please let me know if anything is unclear, I'll happily clarify! Thank you in advance