How to Create a Dynamic Annual Calendar in Microsoft Excel

[@jillianrisse]

This was a super helpful tutorial. Thank you Melissa. Any suggestions on how to add/track important dates in this annual dynamic calendar - based on a separate tab list (holidays, PTO, task names on due dates, etc). I'm not able to add in rows in between/under each week to bring in key notes on specific dates.

[@aldomema6939]

This was great - I am now looking to link my daily data into this. any particular help for that?

[@NelsonFranks-xk1jw]

Very nice and thorough example. I'm trying to make a calendar, but below the day, I would like to have a row where I could display data for that day calculated from another sheet. Are you aware of any way to skip a row using the SEQUENCE function? Thanks!

[@phillips2976]

It sure would be nice if we could download a copy of the final spreadsheet.

[@markowen8725]

Thanks for the Tutorial, I am using an old version of EXCEL(2007 to be precise) so i don't have a sequence option but I did find a work around by manually typing the first 3 rows of dates and dragging them down. My question is can each month be separated into it's own titled box

[@Luran07]

Nice guide. Is there any way to apply the sequence command, if I want to have weekdays presented in rows, instead of columns? Example: First day is in A1 and I need day 2 to be in A2, instead of B1, and so forth.

[@biggc49042]

I am trying to build a calendar that is just for the current month and it switch based on the drop down I choose. I was able to set up a Today, Year and Month drop downs. Think your typical daily calendar with squares. I would like to change the drop down and the dates dynamically change on the headers of the calendar.

[@ItsMe-ic1gb]

I have an older version of Excel which means SEQUENCE isn't working. Is there an alternative to this?

[@andreagraham9640]

I am running into the same issue ...

[@MelCompton]

Hello! What version of Excel are you on. And, is it on a PC or MAC.

[@Missladyoutlaw310]

Could you give us an alternative formula if the sequence formula isn't available? I have excel 2016

[@zero310578]

With this Worksheet Im trying to create a shift rota for 3 Shifts, how to you create rotational patterns using conditional formatting or is that not gonna work?

[@jillianrisse]

This was a super helpful tutorial. Thank you Melissa. Any suggestions on how to add/track important dates in this annual dynamic calendar - based on a separate tab list (holidays, PTO, task names on due dates, etc). I'm not able to add in rows in between/under each week to bring in key notes on specific dates.