Calculating With Drop-down Menu Dates

[JHHPavel]

I have an Excel spreadsheet with drop-down menus for start date and stop date. After choosing them, I want to calculate the number of days in the chosen period. Just subtracting begin from end doesn't work; 3/31/14 - 1/1/14 = 01/04/00 when calculated from the drop-downs. =datevalue(3/31/14 - 1/1/14 ) yields a #Value! message. Is there any way to get Excel to look at the date chosen?

Thanks,

Paul

 

[SkipVought]

Hi,

If you look at the HELP documentation for the DateValue() function, you would see that it uses one text date value.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]