Adding an annual calendar as a drop down item

[Rodev345]

How do I add an annual calender as a drop down item in an cell within my Excel Document?

[#2 · Accepted solution]

@Rodev345 

If you mean date picker it's not implemented in modern Excel. You may vote for this idea here https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054... 

Otherwise create 365 rows column and use it in data validation, but that's not very suitable solution. 

[#3]

@Sergei Baklan 

Thanks for your prompt reply! I will look at other formatting options!

Have a great day!

[#4]

Wow, so beautiful! I like it when people make some really pretty things by themselves. I’m actually a DIY fan and often make smth by myself to improve the house design. Once I found https://www.123calendars.com/september-calendar.html these calendars, I decided to make smth interesting with them. I printed all 12 month blanks and pinned them to a huge wooden base my husband did. Then I put it on the wall and added some artificial flowers, light strips and cute stuff like that. Now all my family members like to write their plans and events on this board!

[#5]

I added a new row to the "NewForm.aspx" and added a dropdown list from the tool pane. When I click on the Data Fields for the drop down list, I see a datatype "Content Type", when I select that it asks me to bind data. This is where I am having an issue. Trying to find out how to get the custom content types I created 2023 calendar printable to populate in that dropdown list.

Any ideas would be a great help.