Make New Year calendar with Excel

At the beginning of the new year, make a new year calendar to give someone New Year's greetings, this mind is very important. There are many ways to make a new Year's calendar, but have you ever tried it with an Excel form in office? below to introduce you to make the calendar with Excel.

Today we introduce the method of making perpetual calendar with Excel. This New year calendar shows the month's monthly calendar, and it's convenient to look at any calendar that belongs to any date. If you want, you can also let it on a special day to display different reminders text, try it together!

The functions involved in this article are:

1, and (Logical1,logical2, ...)

2, DATE (Year,month,day)

3, Day (Serial_number)

4, IF (Logical,value_if_true,value_if_false)

5, INT (number)

6, MONTH (Serial_number)

7, now ()

8, or (Logical1,logical2, ...)

1, start EXCEL2003, create a new worksheet, named Save (such as million calendar. xls), and in the corresponding cells, enter the text shown in Figure 1.

2, select B1, C1, D1 cell, press the "Merge and Center" button on the Formatting toolbar, merge it into one cell, and enter the formula: =today ().

Select the B1 (merged) cell, to perform the format → cell command, open the Format Cell dialog box (Figure 2), select the Date option under category in the Number tab, and then select the March 14, 2001 option under Type, and OK to exit. Set the date to the Chinese form.

Note: The Today () function is used to extract the current system date, please make sure that the system date must be adjusted correctly.