When you apply cell formatting in Microsoft Excel, you quickly standardize how dates and other kinds of data appear in individual cells, workbooks and spreadsheets. After you assign the cell type ...

In many cases, you want people to enter a valid date, and no other type of information, when they're putting data into a cell in Microsoft Excel. For example, you might be asking people to record days ...

The TYPE function is an information function in Microsoft Excel, and its purpose is to return a number indicating the data type of a value. The user cannot use the TYPE function to determine if the ...

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(), ...

Microsoft Excel can perform thousands of different types of data manipulations and calculations. This article will teach you how to use Excel formulas to add a specific number of days to a date. To ...

How to subtotal transactions by conditional date components in Excel Your email has been sent Image: utah778, Getty Images/iStockphoto Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft ...