Thread: date from sheet name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBoulton JBoulton is offline
external usenet poster
  
Posts: 50
Default date from sheet name
I'd like to turn a sheet name into a date.

Apr28 to 4/28/10 (as a date)
and
Apr28-30 to Apr28-30 (as text)

TIA and thanks for any ideas.

Jim
Reply With QuoteReply With Quote