Save Excel Document As Day Before

[harrisj_]

I have this code to save for today. Just wondered where i put the '-1' to save it as yesterdays date


...Document Name" & Format(Date, " dd-mm-yyyy") & ".xlsx"

Thanks

[TMS]

After Date and before the comma ... Date-1,


Regards, TMS