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.
Tag: Calendar
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.