transfer date to number

A

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
 
J

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
Click to expand...

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

where your date is in cell A1.

John
 
Top