How to Make Simple Calendar in Microsoft Excel

One of the functions contained in Microsoft Office Excel is the DATE function. This function can be utilized to create a simple calendar. Although simple, guaranteed you will be satisfied with the following calendar.

How the tutorial? please follow the step by step below :

Step One: Make a Calendar One Month 

1. Make any write formulas that reference numerals represent the month represented (1-12). For example, type 2 for February in cell B4. 
2. Write the reference year we are going to set in cell H4. Examples, 2014. 
3. Then write down the names of the days starting from Sunday to Saturday in cell B5 to H5.
   Note the following images for more details.
   
4.  Block cell C4 until G4, and combine it with the click Merge & Center. 
5. Then write the following formula in the last column
   
   
   Do not be surprised if later emergence of 01-02-2014. To turn it into the name of the month, still in the column and press Ctrl 1, and select Number >> Custom >> enter mmmm on the column type. If you do it right, the result will be as this pic bellow
   
   
6. Next, enter the following formula under Sunday (cell B6).
   
   
   Then you will see name in January. To change it press Ctrl 1, select Custom Number >> >> enter d in the column type, then press Enter.
7. While for the Monday, you just write the following formula in cell C6, namely:
   
   
   and on Tuesday through Saturday you can suppress the drag drop AutoFill (a small plus sign in the lower right corner of the cell) to copy until the cell H6. Then the result would be like this.
   Date calendar month of February 2014
   
   
   
   
8.  The next step is to fill in the date of the next week. In the B7 cell type in the formula:
   
   
   Fill until B10 and H10 is fully charged. The result saw the picture below.
   

 
Step Two: Decorate Calendar

As we saw in the calendar month of February 2014 we have made, there are some dates in January and March.
For more professional, then we will disguise it and make it different from the date of February. Please follow this steps:

1. Blocks range of cells that will be modified, namely B6: H10 (read B6 to H10). On the Home tab, select Group Style, choose Conditional Formatting, click New Rule, in the Select Rule Type select Use Formula to Determine the which cells to format, then the column types available,
   type the formula: =MONTH(B6)<>$B$4
2.  Click the Format button ... to decorate with color (Color) are different, let's say blue with effect Italic, click OK. See picture if unclear.
   
   
   

   
   Then the result would be like this.
   

   

 Step Three: Make a Calendar Month and Other Years

Now we just need to make a drop down calendar months and years to more dynamic and we do not need to make over and over - again.
Please Follow this steps: 

1. Make a list of reference data in the form of 1-12 months at a sell K4: K16. 
2. Then again, click cell B4. Then click the Data tab, in the Data Tools group choose Data Validation. 
3. It will appear the Data Validation dialog box. On the Settings tab, Validation Criteria, Allow, change the Any Value became List. 
4. At the source, click the Range Selector button and then select the data range of reference, namely the cell block K4: K16
   
   
5.  And click OK. Then you will get results like this.
   

Do the same thing for years, Just a different range of reference data cells only, for example to the range of cells you created in cell M5: M11 (for 2014-2020).
Now you just edit them just to make it more attractive. Suppose modified to like this.

 How, Interesting right? While waiting for the next Excel tips, you can immediately practice this simple trick. Good luck! :)