Appending Excel Output with Month, Date and Year Dynamically

HI All,

I am new to this tool so need all the help i can get!. I am looking to add a month/date/year to the final excel output file name . this is a weekly run, so needs to dynamically update the dates. Is that possible?

Example:

File Name : XYZ.xlsx

Rquired FIle Name : XYZ - September 15 2017.xlsx.

Thanks for your help

Output

Accepted answers

AmeliaG

Hi @SR,

Yes, this is possible! This guide details exactly how to make this happen.

Let me know if you have any questions and I'd be happy to help

Amelia

All comments

AmeliaG

Hi @SR,

Yes, this is possible! This guide details exactly how to make this happen.

Let me know if you have any questions and I'd be happy to help

Amelia

NJT

Just putting a shortcut here to the formula used so that next time I can't remember how to do this I'll find it here right away LOL!

"C:\FilePath\FileName_"+[FileDate] + ".xlsx|||SheetName_"+[FileDate]

Altusr1

Any idea Amelia why we can't access this page that you are linking. It says access denied.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335