Excel Forum
Similar Content
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Exce...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Remove All Data Validation from a Cell in Excel
Macro: Remove all data validation from a cell in Excel with this free Excel macro. This is a grea...



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.





Got a Question? Ask it Here in the Forum.