Excel DATEVALUE is a Date and time function, and its purpose is to converts a date in the form of text to a serial number. Learn how to use it.

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical ...

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.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

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.

Using Excel as a scheduling tool is a great skill to have under your belt. Learn how to use SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions.

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.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

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

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.