[Google Spreadsheet] I want to count down the number of days left from a specified date! |DAYS function & NOW function

If you use Google Spreadsheet (commonly known as Google Sheet Spreadsheet), how many more days will it take to reach the specified date…? You can easily count down!

DAYS function

The DAYS function returns the number of days between two dates.

Arguments of the DAYS function

DAYS(終了日,開始日)

[rml_read_more]

argumentexplanation
終了日Specifies the end of the date range.
開始日Specifies the start of the date range.

Note The DAYS function takes into account leap years.

enter a function in a cell

So, let’s use the DAYS function.

First, specify the cell of “end date (test date in this case)”.

Then, if you specify today’s cell (currently blank) as the start date, the result is…

[rml_read_more]

“44166” came out!

44166 (12/1/2020) – 0 (blank) = 44166

This is the result!

NOW function

Use the NOW function to enter the current date and time.

Type =NOW() in the cell.

Today’s date is entered in the cell!

And the result “124” was displayed!

custom number format

I want it to be displayed as “○○ day”, so select “123▼” → Detailed settings for display format → “Custom number format”.

Enter 0 days (or # days) and press “Apply”.

It changed to the display of “○ day”! !

With this, “remaining ○ days” will change every day! When the remaining days are approaching, I think it would be good to “change the color with conditional formatting” or “send an alert message with GAS”!

Please refer to it ^ ^)