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