how to take automatically backup in last day of week

Question

hi

i m tying to take back up of my database in every last day of week

but i can not match and find path and day of my week

suppose i set day Saturday  then project every saturday take bakup in my select path and exist file will be replace

but i m not compaire the last day and how to save path which is always save my software to backup

help me in code and logic