60.8 F
San Francisco
Thursday, September 17, 2020

Excel Calendar

Here’s a complete calendar in Excel using the following formula.

=IF(MONTH(DATE(YEAR(A1),MONTH(A1),1))<>MONTH(DATE(YEAR(A1),MONTH(A1),1)-

(WEEKDAY(DATE(YEAR(A1),MONTH(A1),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””,

DATE(YEAR(A1),MONTH(A1),1)-(WEEKDAY(DATE(YEAR(A1),MONTH(A1),1))-1)+{0;1;2;3;4;5}*7

+{1,2,3,4,5,6,7}-1)

This is the first edition. Each month is on a separate worksheet.  After revisiting this, I forgot how to do arrays in Excel.  Follow theses steps in order for this code to work if you were to start from scratch.

  1. Click on cell A1 and type in a date like: 1/1/2010
  2. Click on cell A2 and highlight 7 columns to the right and 5 rows going down
  3. Paste in the code above in the formula bar for A2
  4. Hold down CTRL and Shift on the keyboard and press Enter
  5. Format the dates as you please

Excel calendar

 

Edel Alonhttp://edelalon.com
Edel-Ryan Alon is a starving musician, failed artist, connoisseur of fine foods, aspiring entrepreneur, husband, father of two, geek by day, cook by night, and an all around great guy.

Related Articles

Installing Rear Sway Bars on Miata NC

Just installing the rear sway bars on a Mazda MX-5 NC (Miata). From the pictures, you can see the difference between the stock and...

Halloween 2020 and COVID

Not sure how Halloween will work this year but it is good to know that companies like Hershey are putting out maps to show...

Working with Federal Office of Rural Health Policy (FORHP) Data Files

FORHP released a couple of excel files that contain information about FIPS and ZCTAs. For people with large amounts of data where they want...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Stay Connected

440FollowersFollow
9,970FollowersFollow
12SubscribersSubscribe
- Advertisement -

Latest Articles

Halloween 2020 and COVID

Not sure how Halloween will work this year but it is good to know that companies like Hershey are putting out maps to show...

Working with Federal Office of Rural Health Policy (FORHP) Data Files

FORHP released a couple of excel files that contain information about FIPS and ZCTAs. For people with large amounts of data where they want...

20 Years On and Still Burning Bright – The Honda S2000

In the modern world, we are constantly pressed to have the latest things, and our cars are no exception. We’re told year after year...

Lion Cake

Documenting a lion cake. Nothing too fancy, just a lion cake.

S2000 Glove Box Organizer

Just highlighting this glove box organizer for the S2000 made by Modify Products. They seem to have other items for sale that fit this...