date translated to value

Hi Excel Experts! I am new to this forum and really need some help. This is probably super simple but I have no idea where to start, would really appreciate your help.

I have several bills due within the next few months (each date is assigned to a different cell) and I would like to translate that into values once the bill due date is here.

Say today is 1st of March
Cell A2 reads that a bill is due out on 2nd March (2/03/19 shown in cell A2). The bill is for £50 (not sure where to insert that value?). So tomorrow when the bill is due I would like for another cell (say A5) to show the value of £50. Is that even possible? I honestly have no idea where to start.

Thank you!

omg thank you! that simple huh? you are awesome! i am away to try this out now.

Could I use similar formula for forecasting? If say I have 3 bills due between March and May, could the total values come up in a single cell meant for budget forecast for March, April and May? This is black magic to me!

You are a saint! thank you, I shall start practicing now

Sambo's last suggestion will always show a rolling 30 day due period, i.e. on 15/4/19 it would look at anything due before 15/5/19.

This will see if it is due this month, but will not compare the year if you have an ongoing list.

=IF(MONTH(A2)=MONTH(TODAY()),B2,"")

This will do month and year, the 0 tells the formula 'this month only', to go to the end of next month, change 0 to 1, the month after, change it to 2, etc.

=IF(A2<=EOMONTH(TODAY(),0),B2,"")

@Sambo, If you use [NOPARSE] tags around (;) it will stop the board changing it to a winking smiley.

thank you Jason, I do have an ongoing list, basically with lots of amounts due within Q1,Q2,Q3 and Q4. I will look at all the options but i have a feeling I may be back with more questions!

thanks guys!

You're welcome!

For current quarter, try

=IF(A2<=EOMONTH(TODAY(),2-MOD(MONTH(TODAY())-1,3)),B2,"")

You guys are magicians