Hey there everyone,
For my work, we are trying to make a calendar to send out to clients every month. Every calendar will be different for each client, and we would have a new calendar each month. I have found online a file I can download that is an excel file that has a calendar for each month of the year with the days in their respective spots. However, when 2013 comes and there's no download like this one, we have to make a new calendar each month. So what we want to do is make one calendar, or more, and have the days automatically fill in when the month is over/starting. I have tried the whole "put A1+1 in B1 and that will change the date". And that does work, until the end of the month comes around. Is there any type of coding or formula that could take care of this for me? I am moderately comfortable with Excel but certainly not a professional so easy to understand answers are appreciated.
Thanks guys and I hope someone can help
Bookmarks