How To Add 3 Different Date Picker Calendars in Microsoft Excel [Free Download]

In this week’s training, I will show you how to add 3 different types of calendars in Excel.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:


TIMESTAMPS:
0:00 - Introduction
0:27 - Overview
2:58 - Selection Change Event
14:49 - Conditional Formatting
18:33 - Cell Next Month
19:40 - Cell Today

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #excelcalendar #freecalendar #datepicker

[adrianbreckenridge]

Awesome! Well explained and the Shape date Picker is brilliant and easy to put into a workbook with the detailed instructions. Thanks!

[CeliaAlvesSolveExcel]

Hi, Randy! I just installed the shape-based calendar and it is working very well. You did a phenomenal job with the code accounting for a number of different situations, and also with the design details! Thank you so much for sharing this.

[macman]

Good lesson Randy! Working through your 150 Excel Workbook Library.

[adriantoma]

Nice tutorial!
PS: I usually show calendar also on double click to make sure it is triggered

[martinargimon]

HI randy, Thanks very much for the Calendars. Just a quick question ? Can we bring up/ call any of these calendars within a VBA form ? Thanks in advance . Martin

[NoraRainey]

I am using Microsoft Office 365 and I do not have a Form folder in VBA. Was this removed in Microsoft 365?

[vickyhartley]

can I use this calendar 'within' an existing user form? I have a booking user form and would like to be able to select a date from a pop up.

[MrKunal]

Randy I need your help to put such a calendar for attendance tracking of an employee.

[srikanthkasala]

Respected sir, I seen your few of videos of you did one. I inspired a lot and I started practice in beginning am facing little bit to do or complete the task. I to learn some basics of programming of VBA.. Sir can you give a link of your 1st video of VBA. I hope it is helpful to me and who are watching your valuable videos they also gain from you thanking you sir

[kennelson]

Randy, I'm missing some of the info you show in the Developer tab/Visual Basics area. How can I communicate with you to show you what I'm speaking about?

[kenmcmillan]

I love your three different calendars and appreciate you preparing. It is possible to use one of these calendars on this file I created which is a 4 week based form, but my company changed accounting periods from a 4 week to a monthly based? The 5th week would change based on the calendar of the year and month and could I tie that 5th week to one of the 3 calendars you created? Thank you.

[DeepakKumar-mszu]

Sir can we use the userform calendar in corel draw please tell me

[VladimirSuazo]

Hi, just found your channel and it has a really great content; You have done a very good job, congrats. I would like to know if there is a way to link any of these calendars to a pivot chart so I don't have to use slicers for the dates.

[kailashsoni]

Hello sir, ❤️


Can I use these cal... In userform?

[MrJunior]

Hi Randy! Thank you so much for the video! I have a question: when I use the code it's giving me the Run-time error '1004' Method 'Range' of object '_Worksheet' failed when I add multiple cells to the code. I added from cell B3 to cell B67 and it works perfectly but when I try to add cell B68 or another one, it gives me the error mentioned above. Any ideas of how to resolve this?

[benosborne]

Calendar one. How do I add it to multiple sheets in on workbook?

[hilarysutherland]

Trying the first form based calendar. I have no "form" on the right I really wanted this to work. Please help

[cecilm]

Request help:
How can I use the in-cell-calendar for a range of cells in my spreadsheet? Thank you.
(ex: I need to input a series of dates in cells A20:M20.)

[dianacouch]

Like the calendar a lot. Ran into an unexpected linking problem:
(Using Excel 2013 on native Windows 10 Toshiba laptop.)

After using the calendar awhile, I began getting a can't link error, although everything in my workbook worked. Tracked it down to a link between my workbook, and the downloaded workbooks used during install. The linking error happened because I moved those files, thinking they were not needed. But as it turned out, 3 Excel Calendars.xlsm is linked, and through it DatePicker.xlsm is linked. But...when I examine links in my workbook, or in the download workbook, the following is found: If I look at Inquire tab:Workbook Relationship, the diagram shows these links as existing. If I look at Data tab:Edit Links, no such links are shown in order to break them. (When I return the download workbooks to their original location, the error stops. Either way, everything works.) In my workbook, I have CalPopUp as Sheet3 (hidden) and Popup_Calendar Module, so I would think these are enough. Yes? This is important, as the finished workbook will reside on someone else's computer. --- Any suggestions? --- Thanks, Doug

[miguelmount]

I wanted to create a calendar macro so I could put the date in whatever cell I select. My version of Excel, which is the latest, does not have the Microsoft Date Control. What can I do? Thanks!