"Duke Carey" wrote in message
...

You'll need to use a helper column in which you put a text formula along
the
lines of this (assuming your first date is in A1)

=year(A1)&text(month(a1),"00")&text(day(a1),"00")

=TEXT(A1,"yyyymmdd")