Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

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

The NETWORKDAYS function in Excel is a date and time function that returns the number of whole working days between Start_date and End_date.

How to Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what ...

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

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

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use ...

The Excel WORKDAY function's purpose is to return the serial number of the date before and after a specified number of workdays. Learn how to use it.

If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.