CONVERT Function in Excel: Convert Units
CONVERT changes units: km to miles, °C to °F, kg to pounds, hours to minutes. Unit codes are case-sensitive.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
ODD Function in Excel: Round Up to an Odd Number
ODD Function in Excel: Round Up to an Odd Number
ODD rounds away from zero to the next odd integer — for example committee sizes that must avoid tied votes.
Read article →GCD Function in Excel: Greatest Common Divisor
GCD Function in Excel: Greatest Common Divisor
GCD returns the largest number that divides all inputs — for simplifying ratios and finding pack sizes.
Read article →EVEN Function in Excel: Round Up to an Even Number
EVEN Function in Excel: Round Up to an Even Number
EVEN rounds away from zero to the next even integer — handy when items come in pairs.
Read article →DAYS Function in Excel: Days Between Two Dates
DAYS Function in Excel: Days Between Two Dates
DAYS returns the number of days between two dates. Subtracting the dates (=B2-A2) gives the same answer.
Read article →LCM Function in Excel: Least Common Multiple
LCM Function in Excel: Least Common Multiple
LCM finds the smallest number all inputs divide into — when two repeating schedules line up again.
Read article →YEARFRAC Function in Excel: Fraction of a Year Between Dates
YEARFRAC Function in Excel: Fraction of a Year Between Dates
YEARFRAC returns the fraction of a year between two dates — for pro-rata interest, depreciation and exact age.
Read article →WORKDAY Function in Excel: A Date N Working Days Away
WORKDAY Function in Excel: A Date N Working Days Away
WORKDAY returns the date that is a number of working days before or after a start date, skipping weekends and holidays.
Read article →NETWORKDAYS Function in Excel: Working Days Between Two Dates
NETWORKDAYS Function in Excel: Working Days Between Two Dates
NETWORKDAYS counts Monday–Friday working days between two dates, optionally excluding a holiday list. NETWORKDAYS.INTL lets you choose the weekend.
Read article →FACT Function in Excel: Factorial
FACT Function in Excel: Factorial
FACT returns n! (1 × 2 × … × n). It grows absurdly fast: FACT(20) is already about 2.4 quintillion.
Read article →DATEDIF Function in Excel: Age and Tenure in Years, Months, Days
DATEDIF Function in Excel: Age and Tenure in Years, Months, Days
DATEDIF is a hidden function (not in the autocomplete list) that returns the difference between two dates in completed years, months or days.
Read article →PERMUT Function in Excel: Arrangements Where Order Matters
PERMUT Function in Excel: Arrangements Where Order Matters
PERMUT counts ordered arrangements — podium positions, codes without repeated digits.
Read article →