Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Examples)

Download File: http://ift.tt/2v5xN3c
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
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.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.