Excel, Date field daily update with (Macro)! Help needed Please

I have spreadsheet that gets open daily with Task Scheduler and than I add Macro to Update Only  $A2 to =TODAY()-1 and the rest of the rows below will update based on: =$A2 and my data will update ba...