Date and Days calculations

In this lesson you will teach yourself how to calculate date and days 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())

todays date

Today’s date and time

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

todays date and time

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

how many days between dates

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

how many days from today

=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

how many days since

=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

days until

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.

add days to date

 

Template

You can download the Template here – Download