Excel Magic Trick 1457 Part 1

Text or Number Date / Times in Functions & Direct Operations (10 Examples)

DESCRIPTION

Learn about how different functions in Excel and Direct Operations interact and interpret Date and Time Values with the different Data Types: Number or Text. Learn how the Functions: SUMIFS, COUNTIFS, COUNT, SUM, EOMONTH, MROUND, DATE and SUMPRODUCT treat Text Dates & Number Dates and Text Times & Number Times. Learn that Direct Operations treat Text Dates and Numbers dates differently and that many Excel Functions treat Text and Number Dates/Times as equivalent.

Related Articles

Positive Subtotals Only: PivotTable or SUMIFS DESCRIPTION See Mr Excel and excelisfun use two methods to add only the subtotals that are positive (ignore negative Subtotals using PivotTable Pivot Table or SUMIFS or SUMPRODUCT functions. [Read More >>>]

Count Mondays Between 2 Dates WEEKDAY or TEXT? DESCRIPTION See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and [Read More >>>]

DESCRIPTION See how to use Power Query (Get & Transform) and a set of Formulas to create a report that Adds Total Units for Each Product, Finds Max Units Sold for Each Product, and Lists [Read More >>>]