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!