How can I create a time counter cell in Google Sheets?

Question

Google Sheets

Hello.
Is it possible to create a cell in Google spreadsheets that would show the current number of days of overdue debt? That is, we set the date when payment should be made, after which the counter adds +1 every day.

Answer 1

You can use the NOW() and TODAY() formulas. For example, the repayment date is in the cell
B5
, then to get the days of delay, it is enough to insert the formula
=TODAY()-B5
A little more complicated, when the date has not arrived, we do not display anything
=IF(TODAY()-B5>0;TODAY()-B5;"")
Example