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 →Excel, SAP, Oracle & automation tips — plus wacky facts
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 →What JSON is, how to read it, how it maps to rows and columns, and how to load JSON into Excel with Power Query…
Read article →PERMUT counts ordered arrangements — podium positions, codes without repeated digits.
Read article →EDATE returns the same day a number of months before or after a date — ideal for due dates, renewals and EMIs.
Read article →Date & TimeLevel: IntermediateAvailable in: Excel 2007+EOMONTH returns the last day of the month, a number of months away from a.
Read article →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 →Stop formatting slides one by one. Use PowerPoint’s Slide Master to control fonts, colours, logos and layouts for the whole deck — and rescue…
Read article →COMBIN counts the ways to choose items when order doesn’t matter — teams from a class, lottery tickets, product bundles.
Read article →MONTH returns 1 for January through 12 for December — the building block for monthly reports and fiscal-period logic.
Read article →REPT repeats text a number of times — best known for quick bar charts inside cells.
Read article →WEEKDAY returns a number for the day of the week. Type 2 makes Monday = 1 … Sunday = 7, the easiest for weekend…
Read article →DATE creates a real date from separate year, month and day numbers — the reliable way to put dates in formulas.
Read article →You blink around 15–20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.