I have to prepare a riport each weak and I would like to automatize it (VBA). I want to save it with the actual date of the week each week.
This way I tried.
to different cell: =TODAY()-2 , =TODAY()+5
(I prepare it on every tuesday thats why -2,+5)
And to another cell:
=TEXT(cell1,”dd/mm/yy”)&” – “&TEXT(cell2,”dd/mm/yy”)
But it just not works out.
By: Antony Smith