transfer date to number

[artisdepartis]

Hi All,

if i get an exceldate, say Fri 01 Jun 07, how can i transform it into
a number like 20070601?

I know the DAY(), MONTH() and YEAR()functions, and also the
CONCATENATE().
However, if I combine these, i get 200761

Many Thx in Advance!

AP

 

[JzP]

Hi All,

if i get an exceldate, say Fri 01 Jun 07, how can i transform it into
a number like 20070601?

I know the DAY(), MONTH() and YEAR()functions, and also the
CONCATENATE().
However, if I combine these, i get 200761

Many Thx in Advance!

AP

Hi there,
Try
=TEXT(A1,"YYYYMMDD")

where your date is in cell A1.

John

 

[Roger Govier]

Hi

Try
=TEXT(A1,"YYYYMMDD")

 

[artisdepartis]

Ofc... Sometimes it can be so simple ;-)

TY!

Hi there,
Try
=TEXT(A1,"YYYYMMDD")

where your date is in cell A1.

John

 

[artisdepartis]

Ofc... Sometimes it can be so simple ;-)

Also to you: TY!