Date Question

[jeancake]

I'm looking for the code that would allow me to a date stamp in the title of the report, but I would need the date to be for the day before.

For example if today is 7/19/2010 I would like the report to read : "Data as of 7/18/2010"

I know that this is basic, but I can't seem to get the code right.

 

[VoG]

If this is in VBA you need code like

Range("A1").Value = "Data as of " & Format(Date - 1, "mm/dd/yyyy")

 

[jeancake]

Worked Perfectly! Thanks. I knew it something so simple.