If you would like to improve your Excel workflows and spreadsheets and in the process save a huge amount of time you might be interested in mastering Excel date functions.

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" for March or "12" for December. The Weekday ...

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

We delve into the Excel Date & Time functions EDATE, YEARFRAC, EOMONTH, and NETWORKDAYS.INT. All are handy for going back and forth in time on retirement dates, expiration dates and more.

If the Excel Date Filter is not grouping by month, enable grouping dates in the AutoFilter menu, set dates in the proper format, etc.

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.

How to Make a Graph With Months in Excel. When you create a graph that includes dates, Excel 2013 automatically spaces the data in chronological order.

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