How to create a drop down calendar in calc?
Perhaps this will be of some help: How do I add a Calendar Picker in Calc?
This one will work in modern LO as well as pre-4.1.1 LO: Q60894