Example: In this example I am looking to return the current date and time in a cell.

If this happens reverse the order of the cells you selected.

Example: In this example I am looking for the total number of days between the ending date and beginning date.

By default, Excel stores the date January 1, 1900 as serial number 1, and January 1, 2016 as serial number 42,370.

Which means that it is 42,369 days after January 1, 1900.

The function only requires two arguments (end date, start date).

It is important to select the end date followed by the start date otherwise your results will display a negative number of days.

Working with dates in Excel can sometimes be a little confusing.

Excel stores dates as sequential numbers that can be used in calculations.

The TODAY and DAYS functions are great at finding the number of days between two dates. This function uses the same format as the DAYS function described above.

Let’s suppose you are only interested in the total number of between two dates. Example: In this example I am looking for the total number of workdays in the month of July minus any holidays.

Now that we have that out of the way let me show you 4 simple Excel date functions that you should know.