Formula for changing date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
This worked, thank you.

Peo Sjoblom said:
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
Click to expand...
 
Back
Top