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.
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.
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.
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.