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

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

Use either keyboard shortcuts or the NOW and TODAY functions to display the current date and time in Excel and Google Sheets spreadsheets together.

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.

Using three Microsoft Excel functions, you can easily parse time components from a full date value.

If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.

Microsoft Excel 2010 has 400 functions in 11 categories. Categories for both spreadsheet programs include Date and Time, Text, Statistical, Financial and Engineering.