Skip to content

Dates in File Save Names

Tips for using dates in file save names.

Q:  Luis Pelaez writes to say that he is having a problem creating a document save name with a formatted date.

A:  You can have problems if you use slashes in file names, such as the standard mm/dd/yyyy date format.  I use a custom format, such as Format(Date(), “mm-dd-yyyy”).  You can create whatever date format you want, and so long as it doesn’t contain illegal characters, it should work in a file name.

About this author

Office 2024 - all you need to know. Facts & prices for the new Microsoft Office. Do you need it?

Microsoft Office upcoming support end date checklist.