Microsoft Excel Functions & Formulas

Use the DATE function to combine columns

with date parts

The worksheet shown in Figure 4-7 uses three columns showing

dates. Column A lists years, column B lists months using numbers

from 1 to 12, and column C contains the days of a month from 1 to

31. These columns have to be combined to show one formatted

date. To do so, use the DATE function.

DATE(year, month, day)

year: This argument can be from one to four digits. Microsoft

Excel for Windows uses the 1900 date system.

month: A number representing the month of the year (1 to 12).

day: A number representing the day of the month (1 to 31).

4

To combine values of cells into one date:

1. Select cells D2:D10 ...