Separating Dates into Diff Columns

[HCA]

How do you separate a date into seperate columns??
i.e. December 15, 1978
from one cell into three different cells, one for the month, one fo
the date, and one for the year.

thanks in advance

 

[Ron Rosenfeld]

How do you separate a date into seperate columns??
i.e. December 15, 1978
from one cell into three different cells, one for the month, one for
the date, and one for the year.

thanks in advance.

Here's one way:

A1: December 15, 1978 (as an Excel date)
B1: =TEXT(A1,"yyyy")
C1: =TEXT(A1,"mmmm")
D1: =TEXT(A1,"d")


--ron