HDTutorial
EN
How to make a dynamic calendar in excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to make a dynamic calendar in excel

257,902 views May 27, 2020 8:36

Watch on YouTube
ChannelKarina Adcock

Description from the creator

1) Use data validation to make drop down lists for the years and months. 2) Use the DATEVALUE and WEEKDAY formulas to make the dates. 3) Use conditional formatting to hide the dates from other months.

=DATEVALUE("1-"&A2&"-"&B2)-WEEKDAY(DATEVALUE("1-"&A2&"-"&B2),3)
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas

SUBSCRIBE: goo.gl/c46YPs

Microsoft Office 365, 2016, Office Insider, Version 2003
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to make a calendar heatmap in excel of average number of births youtu.be/gAp8pL18HsU
- How to make a calendar heatmap in excel youtu.be/nKZPQyt-ZKY

About this tutorial

Karina Adcock published this 8:36 video tutorial on May 27, 2020. It has been watched 257,902 times on YouTube.

Duration
8:36
Published
May 27, 2020
Views
257,902
Likes
2,009

Tags

Share

This tutorial in other languages