Thread: Calculating numerical month (1 to 12) from text date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Claire_S Claire_S is offline
external usenet poster
  
Posts: 1
Default Calculating numerical month (1 to 12) from text date
I have extracted the month from the worksheet name using the CELL function to
give me the month name as text. Is there a way I can convert this to a
numerical month?
Reply With QuoteReply With Quote