WORKDAY.INTL Function in Excel: Due Date With Your Own Weekend
WORKDAY.INTL adds working days with a custom weekend — delivery or SLA dates for a six-day operation.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
NETWORKDAYS.INTL Function in Excel: Working Days With Your Own Weekend
NETWORKDAYS.INTL Function in Excel: Working Days With Your Own Weekend
NETWORKDAYS.INTL counts working days when your weekend is not Saturday–Sunday — a Sunday-only week, or a Friday–Saturday weekend in the Gulf.
Read article →DAYS360 Function in Excel: Days on a 360-Day Year
DAYS360 Function in Excel: Days on a 360-Day Year
DAYS360 counts days as if every month had 30 — the convention some interest and bond calculations use.
Read article →DOLLAR Function in Excel: Number as Currency Text
DOLLAR Function in Excel: Number as Currency Text
DOLLAR formats a number as currency text using your computer’s currency symbol. The name is historic — on an Indian-locale PC it shows ₹.
Read article →FIXED Function in Excel: Round and Format as Text
FIXED Function in Excel: Round and Format as Text
FIXED rounds a number and returns it as text with or without thousands separators — good for sentences built from numbers.
Read article →ISERROR Function in Excel: Does the Formula Return Any Error?
ISERROR Function in Excel: Does the Formula Return Any Error?
ISERROR returns TRUE for any error value. It is mostly used in conditional formatting and checks; for replacing errors, IFERROR is simpler.
Read article →DMIN Function in Excel: Smallest Value With a Criteria Table
DMIN Function in Excel: Smallest Value With a Criteria Table
DatabaseLevel: ExpertAvailable in: Excel 2007+DMIN is DMAX’s twin: the smallest value among matching rows.Syntax=DMIN(database, field.
Read article →DMAX Function in Excel: Largest Value With a Criteria Table
DMAX Function in Excel: Largest Value With a Criteria Table
DMAX returns the largest value in a column among matching rows. It worked in every Excel version long before MAXIFS existed.
Read article →MINIFS Function in Excel: Smallest Value Meeting Conditions
MINIFS Function in Excel: Smallest Value Meeting Conditions
StatisticalLevel: IntermediateAvailable in: Excel 2019+MINIFS returns the minimum of values where all conditions are true.Syntax=MINIFS(min_range.
Read article →PRODUCT Function in Excel: Multiply Many Numbers
PRODUCT Function in Excel: Multiply Many Numbers
MathLevel: BeginnerAvailable in: Excel 2007+PRODUCT multiplies all numbers in its arguments, ignoring text and blanks.Syntax=PRODUCT(number1, [number2].
Read article →Unpivot Monthly Columns into a Clean Table with Power Query
Unpivot Monthly Columns into a Clean Table with Power Query
Turn a wide report with Jan–Dec columns into a tidy Month/Value table using Power Query’s Unpivot — so pivot tables, charts and SUMIFS finally…
Read article →MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS returns the maximum of values where all conditions are met; MINIFS returns the minimum.
Read article →