The day before a given date

  • Thread starter Thread starter Paul Batt
  • Start date Start date
P

Paul Batt

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
 
I believe you are after the DateAdd function.

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