Actually, you can just do the weekday part automatically... so schedule the following once daily:
SET MYDATE=%DATE:~0,3%
IF %MYDATE% == Sun SET YESTERDAYDATE=Saturday
IF %MYDATE% == Mon SET YESTERDAYDATE=Sunday
IF %MYDATE% == Tue SET YESTERDAYDATE=Monday
IF %MYDATE% == Wed SET YESTERDAYDATE=Tuesday
IF %MYDATE% == Thu SET YESTERDAYDATE=Wednesday
IF %MYDATE% == Fri SET YESTERDAYDATE=Thursday
IF %MYDATE% == Sat SET YESTERDAYDATE=Friday
set /a day=%date:~7,2% - 1
ren "C:\Users\Username\Cam\%YESTERDAYDATE%" %date:~10,4%-%day%-%date:~4,2%
move "C:\Users\Username\Cam\%date:~10,4%-%day%-%date:~4,2%" "C:\Username\Cam\Desktop\Archive"