I have a certain cell that is used to input a date. I want to be able to
push a button and copy this date to antoher cell, however I need the
formatting to change from the original date format to a text format that goes
yyyy-mm-dd. I've tried using a custom format and then changing that to text
but the date just changes to a number. Any suggestions?

Thanks

Adam Bush