Date in vba

hi all ,

I have report need to send it every day but it back for the day before so how I can make the date for day before the code that I know it its like this :
" date - 1 "
but that will give me (month-day-year)(2-20-2017) I want it to become (day-month-year) 20-2-2017 how I can make it like this ?????

thanks in advance guys

Actually dates in excel are numbers (since 01-01-1900), what you see (dd-mm-yyyy or mm-dd-yyyy) is just a number formatting. Change the number formatting of the cell

or try this if your date is in a1

=TEXT(A1-1,"dd/mm/yyyy")

or VBA version
Format(Date - 1, "dd/mm/yyyy")

Thanks for your feedback and rep.

Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved"