1 Column 'Date' to 3 Seperate Columns 'Month, Day, Year' How??

K

Ksean

I used to have month, day and year entered in separate columns on my
‘registrants’ sheet, when I did this I used this formula
=IF(ISNA(VLOOKUP(C9,Registrants!$A$3:$Y$1000,7,FALSE))=TRUE,"----",VLOOKUP(C9,Registrants!$A$3:$Y$1000,7,FALSE))
to duplicate the respective values in separate columns on another sheet.

However now the month, day and year on the ‘Registrants’ sheet are in one
column as a common date (i.e. Dec. 12, 1996). How do I modify my formula to
duplicate the year, month or day separately in cells on ‘Forms’ sheet?

FROM: ‘Registrants’ sheet has month, day and year in one column as a common
date (i.e. Dec. 12, 1996)

TO: ‘Form’ sheet needs month, day and year entered in separate columns
extracted from the column on the ‘Registrants’ sheet.

Thanks
Kerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top