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

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
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

Category:

Education

Tags:

• Excel
• 2007
• 2010
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Slaying
• Dragons
• Create
• List
• of
• Dates
• For
• Month
• With
• Formula
• Given
• the
• month
• as
• text
• and
• year
• number
• see
• how
• to
• get
• first
• last
• list
• dates
• for
• YEAR
• MONTH
• EOMONTH
• IF
• ROWS
• DAY
• functions
• from
• given
• using
• function
• ampersand
• one
• &1

[arnoldwilso]

Appreciate the fine videos. Anything more on Stat. like 'correl' and Chitest upcoming?

[ExcelIsFun]

@arnoldwilso , Yes, in the next two months.

[gk039]

Hi Mike,

Just a quick question. How does Excel interpretes month(A1&1) as a number? Do we have to take it as is or is there a logic behind it?

Thanks

George

[ExcelIsFun]

@gk039 , it is just in the programming of the MONTH Function. "Dec1" is just considered a date.

[ExcelIsFun]

@MrKareem79 , what is the formula you typed?

[MrKareem79]

@ExcelIsFun it gives me #value!

[ExcelIsFun]

@MrKareem79 , I am not sure. How is it not working? What error do you see?

[MrKareem79]

firstly, i want to thank you for your useful videos. i tried try use the month function on excel 2007, but it doesn't work. is it really, or am doing something wrong?

[ExcelIsFun]

@devilslowman , I do not know what the problem is. Sorry.

[ExcelIsFun]

@professional80 , I do not know. What error did you get?