Excel Formulas

Test Several Conditions With The IFS Function In Excel IFS replaces a nested IF with a flat list of tests and answers. It has no else, so a value that matches nothing returns #N/A until you add… October 8, 2026 · Excel Formulas Sort By Another Column With The SORTBY Function In Excel SORT can only order rows by a column it returns. SORTBY takes the sort key as a separate range, so you can sort by a hidden column, a… October 7, 2026 · Excel Formulas Build A Link With The HYPERLINK Function In Excel HYPERLINK builds a clickable link from a formula, so a column of links can come from the data beside it. A link to another sheet needs a #… October 6, 2026 · Excel Formulas Get The Day Of The Week With The WEEKDAY Function In Excel WEEKDAY turns a date into a number from 1 to 7. By default the week starts on Sunday, which makes the obvious weekend test flag Friday and miss… October 5, 2026 · Excel Formulas Count Working Days With The NETWORKDAYS Function In Excel NETWORKDAYS counts the weekdays between two dates and can skip holidays. It counts both the start and the end, so it never matches a plain subtraction. October 4, 2026 · Excel Formulas Find The End Of A Month With The EOMONTH Function In Excel EOMONTH returns the last day of any month, leap years included. It first shows up as a serial number, and one extra line turns it into the first… October 3, 2026 · Excel Formulas Calculate An Age With The DATEDIF Function In Excel DATEDIF counts the whole years, months or days between two dates, which is what an age needs. Excel hides it from autocomplete, so you have to type it… October 2, 2026 · Excel Formulas Convert Text To Capitals With The UPPER Function In Excel UPPER converts every letter in a cell to capitals. It is often used to compare cells without case, which the equals sign already does on its own. October 1, 2026 · Excel Formulas Extract The Start Of A Text With The LEFT Function In Excel LEFT returns the first characters of a cell. What it returns is always text, so digits it extracts will not add up until VALUE converts them. September 30, 2026 · Excel Formulas