Formula for changing date format

[Guest]

Is there an easy way to change a date format from mm/dd/yy to yyyymmdd?

Also how would I perform the function of only coping over the year to a new
column once I have it in the yyyymmdd format?

 

[Peo Sjoblom]

1.

=TEXT(A1,"yyyymmdd")

this will make it text, otherwise you can just use a custom format like
yyyymmdd
that way it will still be the same date, however if you type the date as
yyyymmdd it will be the incorrect date


2.

=YEAR(A1)

or

if done on the text function

=LEFT(B1,4)

or if you want a number

=--LEFT(B1,4)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

This worked, thank you.

1.

=TEXT(A1,"yyyymmdd")

this will make it text, otherwise you can just use a custom format like
yyyymmdd
that way it will still be the same date, however if you type the date as
yyyymmdd it will be the incorrect date


2.

=YEAR(A1)

or

if done on the text function

=LEFT(B1,4)

or if you want a number

=--LEFT(B1,4)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com