The more the merrier IMO

"Duke Carey" wrote in message
...
Bob -

Yeah, sure, that is clearly easier, better, etc., but the OP didn't ask
for
the 'best' idea, just for 'any' ideas. Still not enough sleep last night.


"Bob Phillips" wrote:


"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")