View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Atomic Atomic is offline
external usenet poster
 
Posts: 14
Default Need formula or Macro Help

Would appreciate if someone can help me create a (Macro or Formula) that would.

Below when I enter:
07-01-01, 07-04-01, 07-07-01 or 07-10-01

Turn into below:
07-I-01-01, 07-II-04-01, 07-III-07-01 or 07-IV-10-01
(The year needs to be flexible since I must use this for the years to come
like 2008-2020, something like that)

Something where the quarters should result automatically to the month of
each Quarter.

The quarters begins: 01-Jan-Mar, 02-Apr-Jun, 03-Jul-Sep, 04-Oct-Dec