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]
| argument | explanation |
終了日 | 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 ^ ^)