Share via

Creating a calendar in excel that will fill in dates based on month selected

Anonymous
2020-10-12T02:14:46+00:00

Hello, I'm wondering if there is a way to have a calendar fill in the correct dates when you choose a month and year. I have a data validated list of months but need to find out how to make the day and date , as Saturday 12th. Any help is appreciated. Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2020-10-17T15:21:57+00:00

    Hi, 

    Try to keep it simple, something like this:

    After that, just format youR dates to have only dates or months visible:

    If you need help with that, you can reed more on formatting date and time here. 

    Br,

    1 person found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-10-14T05:46:17+00:00

    Hi CrystalCannon,

    Have you referred to the reply provided by advisor above? Please let us know if you still need any further help.

    Best Regards

    Waqas Muhammad

    0 comments