Date and Days calculations

In this lesson you will teach yourself how to calculate date and days in Excel.

Excel provides various built-in functions to perform date and day calculations easily. Here are some of the most commonly used date and day functions in Excel:

1. TODAY(): This function returns the current date.
2. DATE(year, month, day): This function creates a date from the specified year, month, and day.
3. YEAR(date): This function returns the year of the specified date.
4. MONTH(date): This function returns the month of the specified date.
5. DAY(date): This function returns the day of the specified date.
6. WEEKDAY(date, [return_type]): This function returns the day of the week for the specified date. The optional return_type argument determines the numbering system used for the days of the week (1 = Sunday, 2 = Monday, etc.).
7. DATEDIF(start_date, end_date, unit): This function calculates the difference between two dates in the specified unit (years, months, days, etc.).
8. EOMONTH(start_date, months): This function returns the last day of the month that is a specified number of months before or after the start_date.
9. NETWORKDAYS(start_date, end_date, [holidays]): This function calculates the number of working days between two dates, excluding weekends and specified holidays.
10. WORKDAY(start_date, days, [holidays]): This function returns the date that is a specified number of working days after the start_date, excluding weekends and specified holidays.

These functions can be used to perform various date and day calculations in Excel.

Today’s date

I know that today it is 2/10/2021 but I'd like to see it in Excel. To see todays date just use =TODAY() date formula. You will see year, month and day.

To see the number of month use =MONTH(NOW()) or =MONTH(TODAY())

The same with year =YEAR(NOW()) or =YEAR(TODAY())

Today's date and time

To see todays both date and hour as well use =NOW()

How many days between dates?

This time it is all about cell date formatting.

To calculate days between 2 dates just type them in cells (formatted as date) and then just substract cells =B2-B1 in the cells formatted as number or general.

The rule is simple:

• when you want to see date - format as date
• to see number - format as number of general

Days from today

To calculate future date which will be after given number of days just sum TODAY date and the number. Excel today formula is =TODAY()+30

=TODAY()+30 – 30 days from today

=TODAY()+45 – 45 days from today

=TODAY()+60 - 60 days from today

=TODAY()+90 - 90 days from today

=TODAY()+120 - 120 days from today

=TODAY()+150 - 150 days from today

=TODAY()+180 – 180 days from today

=TODAY()+1000 – 1000 days from today

=TODAY()+10000 – 10000 days from today

=TODAY()+1000000 – 1000000 days from today

There will be 4759 year 1 million days from now!

How many days has it been since?

There is also a possibility to calculate how many days has it been since chosen number of days. Use Excel formula =TODAY()-30

=TODAY()-30 to see what day it was 30 days ago

=TODAY()-45 to see what day it was 45 days ago

=TODAY()-60 to see what day it was 60 days ago

=TODAY()-90 to see what day it was 90 days ago

=TODAY()-120 to see what day it was 120 days ago

=TODAY()-150 to see what day it was 150 days ago

=TODAY()-180 to see what day it was 180 days ago

=TODAY()-1000 – 1000 days ago

=TODAY()-10000 – 10000 days ago

=TODAY()-1000000 – 1000000 days ago

There was 1993 year 10000 days ago

Days until

Can’t wait until some date? There is an Excel formula for that as well.

Put the date in the cell and use =A1-TODAY() Excel formula

There are 38 days until spring.

There are 104 days until May 25.

There are 111 days until June 1.

There are 203 days until Spetember 1.

There are 263 days until Halloween.

There are 288 days until Thanksgiving.

There are 289 days until black Friday.

There are 291 days until Hanukkah.

There are 318 days until Christmas.

There are 319 days until Kwanzaa.

There are 324 days until New Year's Eve.

There are 325 days until New Year.

There are 327 days until Groundhog Day.

How many days until zombie apocalypse Excel does not know.

How to add days to date?

It is possible to add days to date.

Put the date in the cell and the number of days in another one. Just add them together and format the cell as date.