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.

Anny suggestions?



By: Antony Smith

Leave a Reply

Your email address will not be published. Required fields are marked *