I'm trying to build one of those calendars where you can select a month and year and it'll show you the next two months as well. But I can't get the consecutive months to update.
I attached a copy so you can see what I'm trying to do.
Ideally, I'd like to select the month and year from cells B3 and C3 and have all three monthly calendars update.
Thanks.
In E13:
=E11-WEEKDAY(E11,3)
In E22:
=E20-WEEKDAY(E20,3)
I have also amended your conditional formatting, which was not correct for the second two months.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Re: 3 month calendar that updates automatically.
How is it that you are so fantastic?
I am so humbled and thankful right now. This is fantastic!
Thank you so much!
Glad to help.
You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks