Excel Magic Trick 324: Dynamic Data Validation List of Dates

See how to create a dynamic list of dates for a Data Validation Drop Down List. See the functions: DATE DAY, YEAR, MONTH, EOMONTH, IF and ROWS. See formulas that work in Excel 2007 and Excel 2003. See how to: Tool menu, Add-Ins, Analysis ToolPak.

DATE function, DAY function, YEAR function, MONTH function, EOMONTH function, IF function and ROWS function.

Category:

Science & Technology

Tags:

• Excel
• dynamic
• list
• of
• dates
• for
• Data
• Validation
• Drop
• Down
• List
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[ajsady]

woow...!! cool...i never try this trick..awesome..

well, can i learn some trick excel 2007 from u??

[ExcelIsFun]

This is an Excel 2007 trick.

[BAINBRYAN]

With Data Validation does to List items need to be in the same sheet or can the List items be in another sheet with in the same workbook. (i.e. the data validation drop down menu is in Sheet 1 A1 and have the list items on Sheet 2 A1:A15)

[ExcelIsFun]

Try this videos:

Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet

[kayno9]

Excellent trick!

[ExcelIsFun]

Dear kayno9,

Thank you!

--excelisfun

[ExcelIsFun]

Dear ziggle314,

Thank you very much! Excel is so much fun and I enjoy making the videos, so I'll keep making more!

--excelisfun

[ziggle314]

Hi Mike,

I agree with tirathmistry. Your work is superb.

Zig

[ExcelIsFun]

Dear tirathmistry,

Thank you for the compliments!

But remember, I am just a guy having fun with Excel. The Smartest Excelers around are at the Mr Excel Message Board!

--excelisfun

[tirathmistry]

Awesome tutorial video ExcelIsFun You are genus really You are No 1 tutor You are Awesome person Your all video tutorials are valuable to all Lerner of excel really Thanks to your kind effort for making tutorial videos from us Your all excel tutorials video are very useful & very powerful very detail & Nicely explain Really people like you who made youtube more popular more interesting & valuable Keep up good work Thanks a Lot With Lot's of Love & Blessing God Bless you