Need VBA code to roll when I roll date in file

This wouldn't work. Today's date was the 29th, but I was reporting for Friday which was the 26th. So I guess said a better way is I am always reporting one workday behind.