Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Formula for Max value | Excel Worksheet Functions | |||
Macro or Formula? | Excel Discussion (Misc queries) | |||
Do I need a formula or Macro? | Excel Worksheet Functions | |||
how to run a macro from a formula? | Excel Discussion (Misc queries) | |||
Macro - formula for end of last row | Excel Worksheet Functions |