EDATE Function in Excel: Add or Subtract Months From a Date
EDATE returns the same day a number of months before or after a date — ideal for due dates, renewals and EMIs.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
EOMONTH Function in Excel: Last Day of a Month
EOMONTH Function in Excel: Last Day of a Month
Date & TimeLevel: IntermediateAvailable in: Excel 2007+EOMONTH returns the last day of the month, a number of months away from a.
Read article →YEAR Function in Excel: Year From a Date
YEAR Function in Excel: Year From a Date
YEAR returns the four-digit year of a date. MONTH and DAY work the same way for the month (1–12) and day (1–31).
Read article →COMBIN Function in Excel: How Many Groups Are Possible
COMBIN Function in Excel: How Many Groups Are Possible
COMBIN counts the ways to choose items when order doesn’t matter — teams from a class, lottery tickets, product bundles.
Read article →MONTH Function in Excel: Month Number From a Date
MONTH Function in Excel: Month Number From a Date
MONTH returns 1 for January through 12 for December — the building block for monthly reports and fiscal-period logic.
Read article →REPT Function in Excel: Repeat Text (In-Cell Bar Charts)
REPT Function in Excel: Repeat Text (In-Cell Bar Charts)
REPT repeats text a number of times — best known for quick bar charts inside cells.
Read article →WEEKDAY Function in Excel: Day of the Week as a Number
WEEKDAY Function in Excel: Day of the Week as a Number
WEEKDAY returns a number for the day of the week. Type 2 makes Monday = 1 … Sunday = 7, the easiest for weekend…
Read article →DATE Function in Excel: Build a Date From Year, Month and Day
DATE Function in Excel: Build a Date From Year, Month and Day
DATE creates a real date from separate year, month and day numbers — the reliable way to put dates in formulas.
Read article →WEEKNUM Function in Excel: Week Number of the Year
WEEKNUM Function in Excel: Week Number of the Year
WEEKNUM returns the week of the year. ISOWEEKNUM follows the ISO standard (weeks start Monday, week 1 contains the first Thursday).
Read article →TEXT Function in Excel: Format Numbers and Dates as Text
TEXT Function in Excel: Format Numbers and Dates as Text
TEXT converts a number or date into text using a format code — needed when you join values into labels.
Read article →FISHERINV Function in Excel: Back From Fisher’s z to a Correlation
FISHERINV Function in Excel: Back From Fisher’s z to a Correlation
StatisticsLevel: ExpertAvailable in: Excel 2007+FISHERINV reverses FISHER, turning z back into a correlation.Syntax=FISHERINV(y)ArgumentWhat it.
Read article →CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT joins text from several cells or whole ranges. It replaces the older CONCATENATE. The & operator does the same for a few cells.
Read article →