Excel Forum

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.