Excel count numbers, with taking day of today in account

I have an Excel sheet that looks like this:

enter image description here

In the column “Total” I have the total amount of minutes that need to be executed.
In the days after the “Todo” column I have the number of minutes that have to be executed that day. Now I want to calculate the number of remaining minutes from TODAY in the “Todo” column.

For ex. on today (26/03/2020) I want to see 65 in the todo column (= 100 – 35). How can I do that?

Leave a Reply

Your email address will not be published. Required fields are marked *