Hi there,
I'm trying to create a calendar the changes month to month and year to year when I select the month and year from a drop down list. I'm having trouble trying to figure out what formulas to use. Does anyone have any tips or suggestions on what to use or maybe I'm missing something?
I've attached the calendar for reference.
Thank you!
Welcome to the forum!
For future reference, the easiest way to do this is to find an existing calendar template and modify it to suit your needs, that way the hard part - the calendar functionality - is already in place. That said, I think I've been able to work it into your sample. I used the following formula in F8:
=IF(WEEKDAY(DATE($C$5,MONTH(DATEVALUE($C$3&" 1, 2017")),1))>1,"",DATE($C$5,MONTH(DATEVALUE($C$3&" 1, 2017")),1))
and in F9:
=IF(F8<>"",F8+1,IF(WEEKDAY(DATE($C$5,MONTH(DATEVALUE($C$3&" 1, 2017")),1))>2,"",DATE($C$5,MONTH(DATEVALUE($C$3&" 1, 2017")),1)))
There are minor modifications as it's filled right for the first week, then a few alterations to get the bulk of the calendar flowing. It seems to be holding up for me, but take a look at the attachment to see if it's working as desired:
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
Thanks a bunch! I'll take a look at the attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks