month/date conversion

[bflan0524]

i know there are various conversion formulas available
is there something i can use that for example if column A row 1 showed a date of 10/16/2018 in column B i could convert to 201810

ty

 

[James006]

Hello,

You can test =year(A1)&month(A1)

HTH

 

[bflan0524]

perfect, ty

 

[bflan0524]

quick follow up, for single digit months is there a way to get a 0 before the # so instead of 20181 it would show 201801

 

[Fluff]

how about
=YEAR(A1)&TEXT(MONTH(A1),"00")

 

[bflan0524]

ty

 

[Fluff]

You're welcome

 

[bflan0524]

hello
one more if you dont mind haha. if i had one column display 201810 for a month and another 201701 and i wanted to determine the difference in months. if i just subtracted them i would get 109, when in reality its a difference of 21 months, is there a way to get it to display the 21

 

[James006]

Shame you did not perform the date difference ... before your transformation to Text ....

Have a go with following : =((VALUE(LEFT(A1,4))-VALUE(LEFT(B1,4)))*12)+ABS(RIGHT(A1,2)-RIGHT(B1,2))

HTH

 

[bflan0524]

that worked, perfect ty
can you tell me what exactly that does, so i can learn it rather then just have somebody tell me haha and i have to bother you guys less haha