Need a date formula to divide a date into 3 columns

C

Caroline

Hi

I have a spreadsheet with a date mm/dd/yyyy.
I need to divide that date into three distinct columns - one for year, one
for month, and one for day.
Is there a formula or formulas that I can use to take the data in the
mm/dd/yyyy format and put it in the right column (mm goes to month, dd to day
and yyyy to year)?
Thanks in advance for the answers!
 
B

Bob Greenblatt

Hi

I have a spreadsheet with a date mm/dd/yyyy.
I need to divide that date into three distinct columns - one for year, one
for month, and one for day.
Is there a formula or formulas that I can use to take the data in the
mm/dd/yyyy format and put it in the right column (mm goes to month, dd to day
and yyyy to year)?
Thanks in advance for the answers!
Click to expand...
Sure. Suppose the date is in A1. The you can use year(a1) in B1, Month(a1)
in C1, and Day(a1) in D1.
 
Top