### Excel Magic Trick 1272

February 20, 2017

DESCRIPTION Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See […]

### Excel Magic Trick 1262

January 16, 2017

DESCRIPTION Convert Times Values to HHMM Text or Text HHMM Values to Time Values Learn how to use the TEXT function and custom Number Formatting to: (00:12) Convert Times Values to HHMM Text with TEXT […]

### Excel Magic Trick 1258

January 2, 2017

DESCRIPTION Add Spaces Between Digits: Custom Number Format & TEXT Function Learn how to use Custom Number Format in Excel to display numbers with spaces and to convert numbers to text with the TEXT Function. […]

### Dueling Excel 119

November 16, 2016

DESCRIPTION Sorting For Plant List, Sort by Month and Day Only See Mr Excel and excelisfun use two methods to override the Sort feature’s default Date sorting technique so that we can sort just by […]

### Dueling Excel 107

September 23, 2016

Count Between Words DESCRIPTION See Mr Excel and excelisfun use three methods to add a leading zero at front and a dash in middle of a number that may be of variable length: 1. Formula […]

### Dueling Excel 73

April 13, 2016

Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions DESCRIPTION See Mr Excel and excelisfun use the functions MOD, LEFT, RIGHT, TEXT, TIMEVALUE, and MOD to coax a time value from a time […]

### Excel Magic Trick 1196

March 14, 2016

YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tipsâ€¦ DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then […]

### Dueling Excel 68

March 9, 2016

Count Dates in Column That Match Year and Month Criteria DESCRIPTION See Mr Excel and excelisfun Count Dates in Column That Match Year and Month Criteria with the functions: DATEVALUE, EOMONTH, LOOKUP, SUM, TEXT, COUNTIFS […]

### Excel Magic Trick 1195

March 7, 2016

Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? DESCRIPTION See how to deal with a Text Date in the form YYMMDD when some of the years are 1900 and some […]

### Display Day Name From A Date

February 23, 2016

If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how […]