Excel formulas to extract 'last visit date' and 'customers who haven't visited in 90 days' from salon visit records

You keep a visit log. But even if you think, 'I haven't seen that person lately,' you can't tell when they last visited without going back through the notes. Is there a way to list all customers who ...
PC World

Use Excel’s DATE, WEEKDAY, IF, and IF/OR to make weekly schedules by task, event and team member

Excel’s SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions came to mind as I was watching a 1969 film called If It’s Tuesday, This Must Be Belgium, about American tourists on a whirlwind tour of ...
PC World

Excel Date and Time functions: WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM, WORKDAY, ...
Geeky Gadgets

NEW Excel Formulas to improve your spreadsheet calculations

The CHOOSECOLS formula is a catalyst when it comes to selecting specific columns from a table. This formula allows you to streamline your data analysis process by quickly and easily extracting the ...