Displaying a Live Calendar in a Range

By -

 



In order to re-create the Live Calendar displayed above in the graphics, carry out the following steps after inserting a new workbook in your excel space:

(1) Just download the graphics and select B2:H2 and merge the cells choosing Home->Alignment->Merge & Center.

(2) Enter a date into the merged range (for e.g. 01-01-2025). The day of the month is not important, so change the format of the cell to a custom format that doesn't display the day: mmmm, yyyy.

(3) Enter the abbreviated day names in the cells B3:H3.

(4) Select B4:H9, and then enter the array formula to the one in the blue square in the graphic above. (Note: To enter an array formula, press Ctrl+SWhift+Enter.


CA Vikram Shankar Mathur
12-Dec-2024 | 03:42 Hours IST | #VSM

Comments

Post a Comment

Popular posts from this blog

20191117-Running-Total-Formula-MSExcel

By Anonymous -
Image
20191117-Running Total Formula in Microsoft Excel Worksheet for Computation of Total Income of an Assessee I have already made a similar post in my Wordpress Blog as VBA Beginners Guide - ( November 2019 ), but here is a more refined version of the same with detailed explanations about the need to create such a running formula. What is a "Running Total" and when is it significant in an Excel Worksheet? The above image is the last part of the image that was added to the final image right at the top of this page, replicated here to ease the explanation of why a " running total " can be required in an excel worksheet. Suppose you had a worksheet, as in my case it is a worksheet that computes the Total Income of an Income-Tax Assessee for the Financial Year ended 31-March-2019 , wherein the various allowed heads under Section 80C, namely, " Public Provident Fund Contribution ", " Life Insurance Premium ", " Children's Educatio...
Read more

Our Team Blogs

By -
LIST OF BLOGS MAINTAINED BY VIKRAM SHANKAR MATHUR SRNO BLOG URL GMAIL_ID 01 https://vsmathurcoin.blogspot.com vsmathurco@gmail.com 02 https://vsmathurcoinshop.blogspot.com vsmathurco@gmail.com 03 https://exceltrainerahmedabad.blogspot.com vsmathurco@gmail.com 04 https://vbabeginner.blogspot.com vsmathurco@gmail.com 05 https://ktvayedaco.blogspot.com ktvayedaco@gmail.com 06 https://ahmedabadfca.blogspot.com ahmedabadfca@gmail.com O7 https://vikramsmathur.blogspot.com vikramsmathur@gmail.com 08 https://cavsmathurin.blogspot.com cavs.mathur@gmail.com 09 https://cavsmathur.blogspot.com cavs.mathur@gmail.com 10 https://vsmathur380052.blogspot.com vsmathur380052@gmail.com 11 https:/’/vsmathur380054.blogspot.com vsmathur380054@gmail.com 12 https://vbacoder1962.blogspot.com vbacoder.1962@gmail.com 13 https://vsmathuricai.blogspot.com vsmathuricai@gmail.com 14 https://deadlyvbaprogrammer.blogspot.com deadlyvbaprogrammer@gmail.com   CA Vikram Shankar Mathur aka the DeadlyVBAProgrammer deadly...
Read more