Actual life saver !!! was attempting to do this for at least an hour and you video helped me through it in 5 minutes !

I need this so much, thanks a bunch. You're basically a life saver.

@AI-ec2qb

3 жыл бұрын

I got a better formula for your 32 days... lol

Excellent!! I am a beginner Excel user and was able to follow along and create a perfect usable calendar for work projects. Thank you for sharing!

You are the master! Thank you for posting this video! Blessings!

Life-saver. Thank you so much!! Love how you answer (like a pro) whoever asks for more info. You're doing a great job, it kinda inspires me to do the same.. For now, hi from a new sub 😁 Will be lurking around and trying out some of your vids

Thank you for the detailed and clear information!

You explained very clearly and I only had to watch it like 7 times to get it, but thank you for time. Your awesome!

So useful! Thank you so much for this very clear and detailed information!

This is great information - I already know someone who could use this procedure - Thank you

Thank you very much for this thoroughly informative video. You explain things so well. I truly appreciate your explanations.

Dzięki. Tego szukałem długi czas :). pozdrawiam

Wow! This is one of the best tutorials I have seen.

This is genius -- thank you so much! I'm using this to create a content creation / review calendar for work. The formatting is great -- and numbering the days of the week with a formula is a huge time saver.

@TheExcelChallenge

6 жыл бұрын

Hello Bill. Thanks for your comment. I'm really happy to read this video was helpful for your work. I hope you can use it as a time saver so you can go and spend that time in other more important things in life, like spending time with the family. Good picture!! T-E-CH

@yarafortes6978

7 ай бұрын

Same reason I can to find the video 😂

This is a very effective tutorial on how to build a interactive calendar. Thanks!

Your video example is truly *amazing*. Can't thank you enough for sharing this incredible information with us here on KZread. My appreciation for Excel has grown, thanks to the instruction that you shared. Continued blessings in return.

@TheExcelChallenge

6 жыл бұрын

William, it is very encouraging to see that my work is helping others on the other side of the PC. Your words are a motivation boost for me to continue producing content that others can use. Blessings for you as well. Come back to see the videos I often post.

Awesome calendar and tutorial! Thank you!! And damn you type fast!!

I liked to follow very detailed examples shown in this video 😊. Thank you !

This is super helpful. Ctrl + drag is the top.

Thanks from Canada!!

Bro you’re simply dope .... I thought it will be very tough... you made it very easy... love you alot.

very informative thank you for making this i really appreciate it!

Thank you for this video! It will help with my backward calendar assignment

Thank you so much for this!!!! Very easy to follow with you and I learnt alot!!! I am preparing a Training matrix for my job this was very helpful!!

Excellent tutorial! thank you so much

This was so helpful. Thank you.

Game changer. Thank you!

Hi, what did you do to highlight the cells when you hover over a category? At the start 0:05

Thank you so much. I really appreciate 😘

This videos was very useful. Thank you so much🩷 keep up to good work.

This is so helpful, thank you so much

I liked your demo. A challenge for me: assigning people (2-4) for different shifts (2, 2hr shifts) for different locations (4-6 locations, varies by lication and by day) for a calendar.

Thank you soooo much this is soooo useful !!

Thank you for sharing! :)

Thanks! This is very useful.

Awesome - thank you so much!!

THANK YOU SO MUCH!!!!

absolutely amazing video

Thank you!

super explanation. thanks.

When you enter items into cells can it be set so it has to be the exact word on your list that changes colour and not if a letter is in the text it changes

Extremely usefull, thanks!

@TheExcelChallenge

6 жыл бұрын

Good to hear you found it helpful Mariana.

Great demo bro!

wow thank you so much

Super helpful!!!

Nicest content I've seen today.

Thank you sir for sharing. GOD bless you

Thanks a lot. It was helpful.

thank you for sharing this video.

Excellent content and very well explained. Is there a way to be able to filter down based off of event and only see those events on calendar once filtered? Please help :)

Hi thank you so much, is it possible to have set dates for categories as well that way they auto populate into the calendar along with color ?

Soo helpful!!!!

How can I get excel to auto fill info. into a specific date cell based on the information entered in another dated cell? Its for a calendar schedule log & I dont want to have to enter followup appointments manually

Many many thanks.

Thank you!!!!!

Dude, your awesome

Great!!

I need this one thanks so much

Thank you soooo much!!!!

Nice work. Thank you! Need your help for a sign-up sheet that calculates the number of registrants and wait list

Thanks!

Thank you so much for this info. Do you know how to copy a template and all the events from one year to the next

Great info

you exceptional

Thank You!

Genius i appreciate the video

Is there a way to filter this calendar by the 'type'; so for example if you only wanted to see the practices you had scheduled for the month.

Many Thanks

Thanks u. I am using this very sheet for my skincare calender

Excellent video well explained

Thank you

Thank you verymuch sir

Awesome!! Very helpful for me.thanks! Can you please make a tutorial of How to create a Swap schedule

thanks very useful

Hi -= this is a great video, so well explained. I'd like to be able to do this for a 6 month calendar instead of monthly, is there a way to turn the formula function off once I've created the calendar so I can write in the same cell as the date?

Thank sir. 😁👍🇵🇭🤓

Thank you so much

Hi, is it possible to allow for more than one colour coded event to show up in one cell? My Calendar is more of a booking system where people can book the same day and time.

Thanks sir

thnx for uploading this video

Great video. But is there a way to convert my data in a spreadsheet automatically into a calendar just like the one in the video? Thanks for any help.

Thank you so muchh😍

It was pretty useful

Thanks

Awesome

Very Nice. Question.. Is there a way to add up at the end of week or month how many Practices, Gym, ETC.. automatically?

wondering if there is a way I can export my outlook calendar into Excel so I can see al my weekly and bi-weekly meetings and make a meeting cadence spreadsheet.

Thanks you so much :_)

Thanks boss

can you please make a video about how the employee attendance record template works in excel? i need some validations and formulas used there but cant figure out how it works. its so complicated for me help please!!

very educational

This is Great! Thanks for the video. Is there any way to make this full page sized for printing? I would like to post this in my kitchen for my family, and I am having trouble trying to make it proportionally bigger to a full page with the template on the bottom.

@TheExcelChallenge

6 жыл бұрын

Hello Mahnia. Thanks for watching. I'm glad to hear you liked it. You can adjust the size of your calendar easy. First select the print area you want printed, and then go to the "Page Layout" tab and click on the "Print Area" button. Then click on the "Size" button and select the size you need. Finally, on the bottom right of the "Page Setup" group in the same tab you will see a small arrow pointing to the bottom right. Click on it to display the "Page Setup" window. In the "Scaling" section of the "Page" tab you will see the "Adjust to" button. Adjust the size of your print out until you are happy with it. I tried 135% and it fits an 8 1/2 x 11" sheet. Now, your printer, row heights and column widths will be different than mine, so just keep adjusting. If you want my file, I can email it to you. Just send me your email address. Thanks for watching.

How I get the space where you can type in your tool area where July is showing on to in you Excel blue area? Thanks

great content bro... salam creator excel from indonesia

How did you turn the colours on and off in starting of the video?

Sir, i wanted to blink the boxes when auto dates changes to the limit which i wanted to change the blink box .... For example when my age reached 22 on auto date system the the box of 22 start blinking but how can i do it in short way?

nice video.

Nice video ❣️❣️

Challenge - I have a spreadsheet that has events in columns and rows, but I want to auto-populate an excel based calendar, without having to cut and paste the values into the calendar. Auto-update of the spreadsheet changes would be a good bonus. I actually have to do multiple months, but If I can get one month to work. I can sort the spreadsheet into months and work it one month at a time. Thank you

Hi. I’m trying to create a 365 day daily diary. I’m using 365 sheets in a workbook the main data is already copied in, I have sixteen people’s events to put in on each day. Some details require dates for future events put in. I’m hoping that the information can then carry over to the specific date of the appointment when that day arrives. Also I would like to be able to create a sheet that can take me to a specific date. I think it’s a pivot chart, but I can’t get my head around it. If what I have asked makes sense, can you help somehow.

Nice video