Looking for a formula to include a date formatted specifically

[blandreth]

Hi,

I'm looking for a formula that will provide the following result in a single cell every time I open the file:

GMR-07-03-2019

Date needs to be in this format (MM-DD-YYYY) as this result will also be saved as the file title.

I appreciate any feedback.

Thanks,
Brian

 

[Fluff]

How about
="GMR-"&TEXT(TODAY(),"MM-DD-YYYY")

 

[blandreth]

How about
="GMR-"&TEXT(TODAY(),"MM-DD-YYYY")

Perfect!

Thank you so much!

Brian

 

[Fluff]

You're welcome & thanks for the feedback

 

[blandreth]

Now that we got the easy one out of the way. I have what I think to be a more difficult question. I need some macro help. Please see my explanation below of how I want the macro to work:

Run macro in working file --> copies a row of data --> opens another file from specified location --> copies the data to the next open row for designated amount of columns --> saves the file --> closes the file and returns to the working file

The data would be pasted in a row for so many columns and the remaining columns in the same row would have formulas that will calculate data pasted. Not sure if this makes a difference, but wanted to add the information just in case.

Any feedback again would be greatly appreciated.

Thanks,
Brian

 

[Fluff]

As this is a completely different question, you will need to start a new thread.
Thanks

 

[blandreth]

Understand.

Thanks!
Brian