Date from Worksheet for name in VBA

I saw an article the other day and lost it. I need to set up worksheet titles that have the date in them using VBA code. I can concatenate text with a date but the date is the number format, not the date format I need. Date shows appropriately in cell I want to pull from.