Excel automatically recognizes common formats, such as "3/17/2012," "Mar 17, 2012" or "17 Mar 2012." Use the Month function to extract the month number from a referenced cell.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

How many days? Excel doesn’t offer a function that returns the total number of days in a specified month, and before EOMONTH () came around, an expression to do so was complex.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...