# How to Create a Day Countdown in Excel (2 Examples)

In this article, weâ€™ll discuss how to use the builtâ€“in functions in Excel to create a day countdown of a future event. This day countdown is commonly used to check and calculate the number of days left to start or end a future planned event, such as a birthday, tour, Independence Day, any sports event, and more.

Watch Video â€“ Create a Day Countdown in Excel

## How to Create a Day Countdown in Excel: 2 Examples

### 1. Use of the TODAY Function to Create a Day Countdown in Excel

Using the TODAY function, we can count down the number of days left to start an event easily. The TODAY function returns the current date displayed in the worksheet and gets updated every time we open the worksheet. This belongs to the dynamic date type that keeps updating while performing calculations. Here is a common template to use.

In this example, weâ€™re going to make a day count down for the Summer Olympics 2024 starting on 26th July. Letâ€™s follow the simple steps below to accomplish this.

Â Steps:

• In cell C3, letâ€™s put the starting date of the Summer Olympics 2024.

• After that, in cell B4, put the following formula.
`=C3-TODAY()`

• Now, press Enter.

The output is in Date format as we subtracted two dates from each other.

• From the Home tab, go to the Number Format dropdown and choose the General format.

• Finally, the Date format is changed to the General format, and the number of days left to start the Summer Olympics in days.

• Moreover, we changed the starting date to the Long Date format to make it more reader-friendly.

### 2. Create a Day Countdown in Excel Using the NOW Function

The NOW function returns the current date and time in a calculation. We can also use this function along with the ROUNDUP function to display a day countdown of the Summer Olympics 2024.

• In cell B4, input the following formula and press Enter.
`=ROUNDUP(C3-NOW(),0)`
Â

Explanation:

The ROUNDUP function rounds up a fractional number to the next integer. It takes two arguments-=ROUNDUP(number, num_digits)
We put C3-NOW() as the number argument of the ROUNDUP function. We used 0 as num_digits as we donâ€™t want any fraction number of days but rather a rounded-up number in the display.

If we normally used the function without the ROUNDUP function, the output would look like this.

After converting the format of the output cell to the General format of the output, it would return a fraction of the number of days left to start the event.

Read More: How to Calculate Remaining Days in Excel

## Notes

Letâ€™s say we have passed the starting date of an event, the countdown will start displaying a negative day number. For example, we can see a countdown for Copa America 2021 that ended 266 days before the date of writing this article.

To avoid this and show 0 instead of the negative number of days, we need to use the MAX function.

`=MAX(0,C3-TODAY())`

## Conclusion

Now, we know how to create a day countdown in Excel using simple formulas. Hopefully, itâ€™ll help you to make your own day count-down dashboard for an event to start. Any questions or suggestions donâ€™t forget to put them in the comment box below.

## Related Articles

<< Go Back to Days Between Dates | Calculate Dates | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Al Arafat Siddique

Al Arafat Siddique, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, has worked on the ExcelDemy project for two years. He has written over 85+ articles for ExcelDemy. Currently, he is working as a software developer. He is leading a team of six members to develop Microsoft Office Add-ins, extending Office applications to interact with office documents. Other assigned projects to his team include creating AI-based products and online conversion tools using the latest... Read Full Bio