I believe you are after the DateAdd function.

dYesterday = DateAdd("d", -1, Now())

"Paul Batt" wrote in message
...
I need to read the date of the day before every given date in European form
(dd.mm.yyyy) from the calendar into a string variable. For instance I have
a variable day1 = "01.11.2006" and need this one minus one day (day0 =
"31.10.2006"). I don't even know where to start doing this in VBA. Could
someone help me a little? Thank you, Paul