Calendar and Date series

DATE(), the English version of DATE(), insuradet an integer representing the specified date. Formula =DATE(2011,02,28) returns the number 40602. If you enter this formula in the cell format was set to General, the result is formatted as a date i.e. 28.02.2011.

in order to create a calendar for a month, it is enough to write one the array formula.

will Create a sequence of dates and times of various types: 01.01.09, 01.02.09, 01.03.09, ..., Jan, APR, Jul, ..., mon, Tue, Wed, ..., 1 sq, 2 sq.,..., 09:00, 10:00, 11:00, ... etc.