Create a Team Calendar in Excel

[@dawnbodden345]

Thank you so much! I just used this today to create a vacation calendar for my Team! Extremely easy to follow!

[@Thebluediamoundvision831]

I can't get Feb correct. The dates are not aligned

[@debbieironside-smith515]

Super easy to follow - thank you for making this - the best one I have found! 😀

[@bhushanjadhav2919]

Thank you so much Definitely by doing this my MD will be delighted. Thank you so much again. Keep up the good work.

[@kalmstrom]

Glad you liked it 😃

[@MattiusMaximus]

Thank you for taking the time to make this and explain it in such easy detail. Really helpful within my new job

[@kalmstrom]

Glad you found it useful!

[@5tivi]

what excatly did you do at 2:03 to replace the hash symbols with dates? I double clicked but it doesn't work

[@nudger1965]

You will need to select all the cells you want to expand from the column header (The A,B,C bit at the top of the sheet) then move your pointer until you get a double sided arrow icon, then double click.

[@praying4ourcountry]

I have tried and tried to get the dates to autofill in the blocks for the days of the month but it is not working I have tried to do the control shift and left arrow but it does not work for me. What am I doing wrong? HELP

[@theohaywood4199]

This was exactly the kind of video I was looking for. Thank you for creating this video I found it very informative and very very helpful.

[@iHartULuv]

Thank you!! I have been looking for this “how to” for so long!!

[@Noora450]

Hallo , thank you so much , I tried to write DDD to chnage but its not chnaged into weekley days , it was also showed DDD without naming the day. Could you plkease tell me why

[@kalmstrom]

Most likely the cell is not formatted as a date. Also, it might be a regional setting. My best guesses!

[@Noora450]

@@kalmstrom many thanx , i got it and now everthing is good many thanx

[@EfieldHfield_377]

Thx for ;sharing. I learned a lot of nice tricks

Glad you liked it 🙂

[@elorisa]

You are a Hero, Clear and simple, thanks a lot

[@kadalikavi4038]

Very useful one. Thanks for the demonstration.

Glad you liked it!

[@sagayapanneer9052]

Program evaluation review technique markings are for buildings

[@donovang6911]

Thank you so much, much easier than finding the template I wanted to download

Glad you liked it 🙂

[@snehsingh933]

after watching many videos, I finally find the right one

[@loumas846]

Thanks a lot. Really helped me.

[@kalmstrom]

Glad you liked it 🙂

[@alanprice3184]

there is a problem in the calendar. when you copy it over to do Feb March etc. It doesnt flow and throws up an error in the days once you change the month on the date.

[@kalmstrom]

What error are you getting?

[@paularisley2164]

Great video! I created mine as a weekly job schedule. I need to be able to archive the week when the new week is avaiable and have the new week show up automatically. I have NOOOOOO idea how to do what I want. I can create a Archive sheet but how would I have the current week tab automatically copy to the bottom of the archive sheet? Any idea would perfect this job schedule for my company.

I am glad you liked the video. Having things happen automatically in Excel is not trivial and requires some kind of programming.

[@paularisley2164]

@ I created the macro to copy the weekly sheet over to an achive sheet and got it to get the weekly sheet to then come up automatically. Now my issue is changing the dates automatically. Doesn't look like I can do that because If I take the last cell which would be =g1+1 to give the last date and copy that value to cell a1....I can't get the formulas to work on the top row to add 1 because it causes a circular reference. There's got to be a way for it to create the new week of dates at the top.

[@kalmstrom]

@@paularisley2164 Sounds like you are making great progress. I would suggest using the VBA code to change the first date cell also.

[@yeshabrahmbhatt4303]

Nice one. Simple yet effective.

[@TheAlienware89]

And how to make it dynamic?

Could you elaborate on what you mean by dynamic?

[@pemotor541]

Just what I needed! Thanks a bunch!

[@kalmstrom]

Glad you liked it :-)

[@carlarobinson1388]

I can’t see the dates on the # signs how can I see the dates ?

[@kalmstrom]

Sorry, Carla - I don't understand your question. Could you elaborate a bit more so I can understand and give you a better answer?

[@fogrisk3537]

great. but need change czech Pondeli to engl Monday. Dont know how .......

[@kalmstrom]

Check both your Office and Windows language settings. It is indeed tricky.

[@kirank6476]

Hi, not all the months are 31 days, you selected FEB also 31 days. How to find the correct days for the month without looking at the calendar?

[@katerinagondarovskaya1789]

Peter, thank you. It's indeed an amazing idea :) As for me, I use a time off calendar in TMetric, it offers a simple yet detailed view of my teams' time off.

[@kalmstrom]

I guess that is a sign of success, that people are using the comments section of my videos for product placement 😃

[@nikolaimochalov7863]

Hi, I am trying to make hourly-monthly calendar. What I mean is , instead of the names - There supposed to be hours from 9am to 9pm, and every day I want to insert names. example : Jack - 9am to 12am, Mark - 12am to 15am etc. Unfortunately i couldn't find it in any tutorial or website.

[@kalmstrom]

We would be happy to build you a calendar to your specifications, but we would have to charge for that work. Contact at [e-mail]

[@stephaniesocgfack4333]

This is amazing. Thank you.

[@SuryaPrakash-pr2ei]

super....which screen recording software you used?

[@Guzunica]

loom.com

[@marianacurcudel4613]

Simple and easy :) Very good example to start from. Thank you!

Glad you liked it :-)

[@donovang6911]

I just learned that if you just change the month (for the days of the week) it won't auto populate the rest of them - unless you re-enter the date completely. Almost didn't catch it before I sent it out!

[@tarunbhola212]

If I change the month from january to feb will it change the respective dates too?

[@kalmstrom]

Yes, the dates will change.

[@bilalwaseem8191]

please tell me which was the formula used here

[@kalmstrom]

I used mostly table-formats and conditional formatting in this video. Could you elaborate on which formula you are looking for?

[@jensmash]

When i try to copy the template and just change the start date and then drag, even after fitting the hashtags don't disappear. Edit: I figured out a way. Anyway thanks for the video.

[@gaia260686]

This was so helpful. Thank you.

[@MegaTinni]

Would be helpful if you'd show what you are making first.

Correct

[@chanelhoward7199]

Thank you - that was clear and concise!

[@seancpcp]

Awesome presentation.

[@piyushkonher8405]

What if we have different weekoffs

[@kalmstrom]

You can simply mark them with the yellow color as I shown in the demonstration.

[@olivierjonard1872]

There is no template for this in Excel somewhere for this? Millions of people on this planet spending 15 - 30 minutes to do the same. I would like to show months and calendar weeks as well.

[@mdsoibe6282]

Nice video ❣️

I am glad you liked it 🙂

[@GlobalNewsImpact]

very helpful indeed... Thanks Alot !

[@asmakhadka4993]

Thank you it was helpful

[@Salem309Y]

This is very informative

[@kalmstrom]

I am glad that you found my demo informative.

[@tazminbhatia3522]

Very Helpful! Thank You!

[@kalmstrom]

Welcome!

[@vanessasigurdson2061]

Very helpful!

[@alokghosh9311]

Excellent...

[@schlagerclub]

This is a very simple and manual way of creating a team calendar. Unfortunately, this is quite static and weekends, months, public holidays etc need to be updated template by template again and again. This is quite time consuming. I'd appreciate an at least little more dynamic overview, eg. with a combination of a table with the data and and a pivot table. No VBA needed for this either... Nevertheless, thanks for the video. For users with little experience, this is certainly helpful.

[@gporoi]

Thorsten G hello there, I’m not quite sure I understood your request but a conditional formatting rule would work perfectly.

[@schlagerclub]

Gaby Poroi Yes, you‘re right, conditional formatting would easily make weekends visible, but that was not my point. This calendar is quite basic and good for beginners to „draw“ a calendar from scratch. When using Excel, my aim is to try to make such tables as dynamic as possible. In this respect, I‘d prefer a solution that is e.g. - able to count / add up marked days (not so easy when cells are merged like in this example), - create a monthly table only by selecting the desired month and year from separate cells and so on. There are several according tutorials on YT. But as said before already: Good for beginners to start with and to create a new project. Always good to learn something new. 😉👍 So again thanks for the video! 🙂

[@gporoi]

Thorsten G Don’t thank me for the video mate. I’m not part of their team. I didn’t do this video tutorial. Also, like I said, I wasn’t sure I got it right, but thanks to your reply, it turned out I really didn’t understand your request.

[@manalis5932]

Excellent

[@prasadrk6507]

Thanks a lot.

[@maysarahamed1902]

Excellent