|
Featured Tutorial
Featured Macro
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.
DATE function, DAY function, YEAR function, MONTH function, EOMONTH function, IF function and ROWS function.