Hi I have the following code that names a file with a prefix and then the
date. I need the date to be - 1 day. Can anyone help?

sFilename = "CNLOPB " & Format(Date, "d-mmmm-yy")

Thanks,
Cathy