Programming an Excel spreadsheet with date binding, perhaps?

Question

excel

The next question, I want to make the work with suppliers more transparent. To be able to understand the status of payment at the current moment at a glance. As I see it:
Considering that today is 09.04.
Let's say the program knows that there is a supplier A, B, and C, with monthly payments. And that supplier A issues an invoice on the 15th of each month, and B on the 7th, C issues invoices 3 The
question is whether it is possible to do this in this form. If yes that how to force to look in current date. And how to set values ​​to the table in a similar way. MB there are some resources where there is information on the topic.

Answer 1

There is a function TODAY () (TODAY), it returns today's date.
In general, you can get confused, specify conditions in the cells (if the date is < today ... ) and then use conditional formatting by cells.
But in general, there is a good collection of programs - 1C is called. I'm sure it will fit.

Answer 2

Excel formulas have functions for getting and comparing dates. Actually the best source is help exclamation. Well and exceltrics