Wednesday, 1 May 2019

Use Excel to Calculate How Many Days Until an Event

 

Excel treats dates as integers. This means you can add and subtract them, which can be useful for telling you how many days there are until that next deadline or event of yours. In this article, we will use Excel’s DATE, YEAR, MONTH, DAY, and TODAY functions to show you how to calculate the number of days until your next birthday or any other annual event.

Excel stores dates as integers. By default, Excel uses “1” to represent 01/01/1900 and each day after that is one greater. Type in 01/01/2000 and switch the format to “Number” and you’ll see “36526” appear. If you subtract 1 from 36526, you can see that there were 36525 days in the 20th century. Alternatively, you could enter a future date and subtract the result of the TODAY function to see how many days away that date is from today.

A Quick Summary of Date-Related Functions

Before we dive into some examples, we need to go over several simple date-related functions, including Excel’s TODAY, DATE, YEAR, MONTH, and DAY functions.

TODAY

Syntax: =TODAY()

Result: The current date

DATE

Syntax: =DATE(year,month,day)

Result: The date designated by the year, month, and day entered

YEAR

Syntax: =YEAR(date)

Result: The year of the date entered

MONTH

Read the remaining 24 paragraphs



from How-To Geek http://bit.ly/2H1fWxJ

No comments:

Post a Comment