How to Make a Cell on Microsoft Excel With a Changing Date. Microsoft Excel offers a Function Library with formulas that insert the current date when you open the worksheet or enter calculations.

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

The TIMEVALUE function in Microsoft Excel is a Date and Time function, and its purpose is to convert a time in the form of text to a serial number.

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

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 ...

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.

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