Just use

=TEXT(TODAY(),"yyyymmdd")

in a cell, or even just

=TODAY()

and format as "yyyymmdd"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
I have an Excel report that I have to run every day. It requires one
piece of manually entered data. I have to type in the date in the
format yyyymmdd (ex. 20060713). If I could figure out a way to get
this data into the program automatically, then I could set the macro to
run on a schedule and I wouldn't have to do it every morning.

Any help is appreciated.

TIm