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

When it's time to set a date, you have a wide variety of options in spreadsheet programs such as Google Sheets and Microsoft Excel. There are essentially three types of dates you can set: dynamic, ...

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000, which is the only version that explains how this function works.

Unlike incrementing a whole number, incrementing the month of a date requires a little more effort in Excel because the calendar months have varying numbers of days. Microsoft gives you a couple of ...