Last week I explained how Excel uses its own, unique system of serial numbers to calculate dates and times.

That piece covered nine Date & Time functions: NETWORKDAYS , DATEVALUE , NOW , DAY , MONTH , YEAR , HOUR , MINUTE , SECOND , plus the basic SUM function for adding and subtracting start dates and end dates.

This week I ll explain how to use seven more Date & Time functions: DATE , DAYS , DAYS360 , TODAY , TIME , TIMEVALUE , and WEEKDAY .

Notice the Formula result in the bottom left corner of this dialog also shown at center right .

In the End Date field box, enter the day, month, and year of the end date inside double quotes; e.g., 5/29/2016 using slashes or dashes.

Or just move your cursor to A7 and type: DAYS A4, A5 .

The text above is a summary, you can read full article here.