Insert Calendar with Data Validation

[U16426]

Hi,

Is it possible using data validation to have a calendar pop up in Cell A2 so the date can be selected from the calendar instead of manually have to type in "mm/dd/yyyy" each time?

I've searched online and see how you can get a calendar on your page but, I only want it to appear when clicking within Cell A2

Thank you

 

[Peter_SSs]

Might this be any use to you?

 

[U16426]

Might this be any use to you?

It kind of works. I can use this at home but, the file I am making is for work. We can't download external files from websites. There is whole process I would need to go through with our IT department to get it approved, even if it's just excel. Yes, I know, good ole IT spoiling the fun.

I guess they will just have to manually type in the date, oh well.