Hi Guys,

I am using excel 2007 and trying to find a fancy way to enter a date in a cell, such as clicking the cell and a Calendar appear were you can pick the required date (Year, Month, Day) (instead of a drop down menu which could be very long and annoying if trying to cover 3 years) .

your help and thoughts on this one is appreciated.

Thanks.