DATEDIF() : Excel’s Hidden Gem
Here we look at how to use Excel’s undocumented DATEDIF() function to calculate durations between two dates, expressed as the number of whole or part months.
Excel
Date Functions : Excel Calendar (Part 2)
Here we look at how to use the DATE() function and MATCH() lookup against named ranges to populate our Excel calendar with key dates and events. Can be used as a project tracker.
Date Functions : Excel Calendar (Part 1)
Here we look at how to use Excel’s date functions WEEKDAY() and EOMONTH() to create a custom calendar, compatible with any month in any year.
Calculate VAT in Excel
Here we look at a formula that will calculate the Net Amount and VAT Amount from any expense. Ideal for keeping track of quarterly VAT accumulation.
Rock Paper Scissors
Here we look at how to use drop-down lists, lookups and conditional formulas to teach Excel to play "Rock Paper Scissors".
Rank by Multiple Criteria in Excel
Here we look at a formula that will automatically sort a data set by two or more text fields. Ideal for outputting names and departments into alphabetical order.
Why INDEX-MATCH is better than VLOOKUP
Here we look at the many uses of the INDEX(MATCH()) combo formula, and why it is a superior replacement for the commonly-used VLOOKUP() and HLOOKUP() functions.
Calculate Time Elapsed using NETWORKDAYS()
Here we look at a formula that will calculate the duration of a project in working days, and learn how to express the % completion of a project against its target duration.
Tax Year Excel Formula
Here we look at a formula that will calculate the tax year for any given date. Ideal for Expenses forms and accounting functions.