The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

If Microsoft Excel does not recognize dates, then there is something wrong with the formatting. Use any of the methods mentioned here to format cells perfectly.

Q. I receive Excel spreadsheets regularly that contain dates. I have to manually look up the day of the week that represents these dates. Are there any functions that can help speed this process along ...

I’m sharing six of those essential Excel functions that I wish I had learned much earlier. I’m confident that they will make a huge difference in your work, too.

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

Microsoft Word has a date field, but it's not easy to use in an expression. If you need to update dates in a document, use Excel to calculate the dates and then run a mail merge.

Microsoft announced an Excel update that lets users disable the automatic conversion of data into dates. Here's how to change the setting.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.