An array formula calendar

Figure 3-6 shows a worksheet set up to display a calendar for any month. Believe it or not, the calendar is created with a single array formula that occupies 42 cells.

I December Vj 4 f

Jj 2003

M A ► H / Nondiscrete_Distribution / Crosstab ¿Calendar /

I December Vj 4 f

Jj 2003

December 2003

Sun

Moil

T11 •:■

Wed

Thu

Fri

Silt

1

2

3

4

5

6

7

8

9

18

11

12

13

14

15

16

17

18

19

20

21

22

2)

24

25

26

27

28

29

Î0

31

M A ► H / Nondiscrete_Distribution / Crosstab ¿Calendar /

Figure 3-6: One array formula is all it takes to make a calendar for any month in any year.

tj.r

Figure 3-6: One array formula is all it takes to make a calendar for any month in any year.

The companion CD-ROM contains a workbook with the calendar example as well as several additional array formula examples.

Was this article helpful?

0 0

Post a comment