Dueling Excel

Dueling Excel 68

March 9, 2016 0

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 Is Fun

Excel Magic Trick 1195

March 7, 2016 0

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 […]

Tricks & Tips

Display Day Name From A Date

February 23, 2016 0

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 […]

Dueling Excel

Dueling Excel 51

November 18, 2015 0

Extract Dates from Cell With Dates and Words DESCRIPTION See Mr Excel and excelisfun Extract Dates from Cell With Dates and Words using two different methods. See the functions: DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, […]

Dueling Excel

Dueling Excel 044

October 7, 2015 0

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 […]

Dueling Excel

Dueling Excel 038

August 26, 2015 0

Weekly Report Formula or Pivot Table? DESCRIPTION See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Reports using a Pivot Table (PivotTable) and a series of formulas. Learn about: 1.Formula for […]

Excel Is Fun

Excel Magic Trick 1146

July 27, 2015 0

Create ISO Dates using TEXT function and Custom Number Format DESCRIPTION See how to: 1. Create ISO Dates using TEXT function and Custom Number Format. Like; =TEXT(A5,”yyyymmdd”) 2. Compare two columns of formulas to check […]

Excel Is Fun

Excel Magic Trick 1145

July 23, 2015 0

Create Random Data Set with Formulas: 4 Unusual Formulas DESCRIPTION See how to: (00:08) Overview of Different data Types (01:02) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers (02:10) Keyboards […]

Excel Is Fun

Excel Magic Trick 1144

July 20, 2015 0

Top 3 TEXT Function uses ISO Date to Date , Text Time To Time , Date To Month DESCRIPTION See how to: (00:07) Text Function and Custom Number Formatting (01:08) Convert Serial Number Date To […]

Excel Is Fun

Excel Magic Trick 1140

July 6, 2015 0

VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels DESCRIPTION See how to Create Text Formulas For Finance Tests where you can change the variables PV, APR, Years and compounding periods per […]