IF function Excel Vba (Auto Date Changing)

See Image Here

As you can see the above image, now i want that,

where is 11-jun-2018 (i used =today() ) for current date, then i want in back column yesterday where you can see (8-jun-18), and as on to 3-jun-2018).