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.
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 how to use drop-down lists, lookups and conditional formulas to teach Excel to play "Rock Paper Scissors".