To write a countdown days formula n Excel, you need to specify a date for which you want to create the countdown. Along with that, you need to use the TODAY function. When you deduct the future date from today’s date, it returns the remaining days. As you are using TODAY which is volatile and updates the date every day. It creates a countdown for the remaining days.
In this tutorial, we will learn to write this formula.
Excel Formula to Get Countdown for Remaining Days
You can use the below steps:
- First, enter (=) equals in a cell to start the formula.
- After that, refer to the cell where you have the date.
- Next, enter the (-) sign for subtraction.
- Now, enter the TODAY function without any argument.
- In the end, hit enter to get the result.
Once you hit enter, it returns the count of days which are remaining from the future date you have specified.
In this example, the date is 10-Feb-2023, and the date returned by TODAY is 18-Jan-2023.
And when you deduct it from the future date, you get the remaining days.
As I mentioned earlier, TODAY is a volatile function, and when the date changes in your system, it also changes the date returned by it which makes it a countdown.
To make the result of the formula more meaningful you can combine it with the test value.
=A1-TODAY()&" day(s) remaning."