Countdown in Google Spreadsheets?

Question

Google Sheets

Is it possible to make a countdown by day in Google Spreadsheets? That is, a certain number is entered into the cell, which should decrease by one every day.

Answer 1

Required input parameters:

1. The number itself
   
2. Date from which to start counting
   

That. formulas can be used to calculate the required value. For example,
=B1+INT(B2)-INT((TODAY())), where В1- given number, В2- start date.
Same thing, but without typecasting
=B1+B2-TODAY()
or one formula
=8+INT(DATE(2019;1;21))-INT((TODAY())), 8- given number, DATE(2019;1;21)- start date
Same thing, but without typecasting
=8+DATE(2019;1;21)-TODAY()
Live example