Excel Magic Trick 848: Create List of Dates For Month With Formula

Download Excel Start File: people.highlin...
Download file: people.highlin...
Learn how to:
1. Given the month as text and the year as a number, see how to get the first of the month and the last of the month and a list of dates for the month.
2. Learn about the YEAR, MONTH, EOMONTH, IF, ROWS and DAY functions.
3. See how to extract the month as a number from the month given as text using the MONTH function and ampersand one &1