Calendar and Formulas

[John]

I want to put a calendar in a file I've created but also want to use the
workdays formula based on the dates selected within this calendar. I can't
seem to do it - is it possible.

Failing that I thought of a nice combo box with dates set in a named range
but can't get that to work either - can that be done?

Thanks

 

[Ron de Bruin]

Hi John

http://www.rondebruin.nl/calendar.htm

Try this to select dates in the calendar control and place them in a worksheet cell.
You can use this cell in your workday function then

 

[John]

Thanks Ron, went through your e-mail help today, very informative

 

[Ron de Bruin]

Post back if you need help John