Calculate This Friday's date and reformat VB

[tvman5683]

Hello,

I'm trying to identify an excel file (that I append to) that changes name every week on Friday. I found a few example that will correctly calculate next Friday's datebut I need to change the format to match the excel format. File is saved as Mysheet 01-15-16.xls. The code below returns 1/15/2016.
any help would be greatly appreciated.

NextFriday = Format(Date + 8 - Weekday(Date, vbFriday), dd - mm - yy)

 

[Joe4]

fyi, you had it right the first time. No need for the replace even though it also worked perfectly!

Sorry, I forgot to mention that part. Yes, when you change the variable declaration to String, there then is no need to use the Replace function.