Using the NOW() function, you can create a countdown timer in Google Sheets that keeps track of the days, hours, and minutes until a certain date.
The step-by-step illustration that follows demonstrates how to use this function to make a countdown timer in action.
The quick steps are:
- Enter the Countdown Date
- Create the Countdown Formulas
- Update the Countdown Timer
DON’T MISS: HOW TO CREATE A CRM IN GOOGLE SHEETS (STEP-BY-STEP)
In This Article
Step 1. Enter the Countdown Date
Let’s say it’s today, 2.3.2022.
I’ll make a countdown timer in Google Sheets that displays the duration in days, hours, and minutes till 2/10/2022 to provide a thorough example in this guide.
Step 2. Create the Countdown Formulas
Next, we may use the calculations below to determine how many days, hours, and minutes remain till 2/10/2022:
Days: =INT(A2-NOW())
Hours: =HOUR(A2-NOW())
Minutes: =MINUTE(A2-NOW())
Each of the following formulae may be entered into its cell:
This indicates that it will be 6 days, 12 hours, and 42 minutes before the date of 2/10/22.
DON’T MISS: HOW TO COUNT THE NUMBER OF CELLS NOT BLANK IN GOOGLE SHEETS
Step 3. Update your Countdown Timer
By selecting Settings from the dropdown menu after clicking the File tab on the top ribbon, you can make sure that the numbers for the countdown timer are updated every minute:
Then select On change and every minute from the drop-down menu next to Recalculation, then click the drop-down arrow next to Save settings.
The values for the days, hours and minutes on the countdown timer will now be updated automatically every minute.