Mac Forum / Applications / Excel / July 2008

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!