Hello!

I have had great success (fun) finding out the following code:

MkDir "C:\Temp\" & Format(Now -1, "mm-dd-yy") & ""
ActiveWorkbook.saveas Filename:="C:\Temp\" & Format(Now - _ 1, "mm-dd-yy") & "\File" & Format(Now -1, "mm-dd-yy")

However this does not help me when I am running the code on a Monday! If anyone knows what I can write to get the current business day minus 1 business day (not calendar day) in that "Now" part, I would greatly appreciate it! Thank you for any direction.

Best regards!