Thread: Date conversion
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
programmernovice[_2_] programmernovice[_2_] is offline
external usenet poster
 
Posts: 61
Default Date conversion

I'm wanting to convert a date to a related symbol string.

Example: 7/16/21 to "210716"

12/17/21 to "212217"
Note that when month has a single digit, a "0" must be added before it in the string.

Can't figure out how to do it using Excel functions. Any ideas would be greatly appreciated.