What errors ? What do they say ?

For yesterday:
Format(Date - 1, "ddmmyy")

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Sheetal" skrev i melding
...

I put the command you gave me into my code, and took out the quotation
marks, but my code is still coming up with errors. The dates that I am
working with, are 1 day behind. how can i sort this out?

Thank you so much for your help


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/