Separating Dates into Diff Columns

  • Thread starter Thread starter HCA
  • Start date Start date
H

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
 
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.
Click to expand...

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
 
Back
Top