Excel Calendar by Month

New Contributor

How do i change the dates in the calendar for each month?

5 Replies

@JulieClark13 What "Calendar by Month"? Are you using a template? Would be helpful if you could show which one.

2022 JANUARY MONDAY
CALENDAR YEAR CALENDAR MONTH FIRST DAY OF WEEK
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
27 28 29 30 31 01 02

03 04 05 06 07 08 09

10 11 12 13 14 15 16

17 18 19 20 21 22 23

24 25 26 27 28 29 30

31 01 02 03 04 05 06

the month has a drop down but it doesn't change the dates

@JulieClark13 

If I may add...

Create a calendar by using a template

Many calendar templates are available for use in Excel. A template provides a basic calendar layout that you can easily adapt for your needs.

thank you i have chosen another one that works, thank you so much