Excel DATEVALUE is a Date and time function, and its purpose is to converts a date in the form of text to a serial number. Learn how to use it.

The Excel WORKDAY function's purpose is to return the serial number of the date before and after a specified number of workdays. Learn how to use it.

Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.

How to Use Month and Weekday Functions in Excel. Microsoft Excel's Month and Weekday functions output numeric values for a given date. The Month function results in the month numbers, such as "3 ...