Text to quarter ?

Options
EXART
EXART
in Modeling

Hello Everyone,

what is the best formula that we can use to go from this to this:

Txt Period "Format Text" (Example: Q1 FY24) ===> Quarter "Format Quarter" (Example: Q1 FY24)

Tagged:

Best Answers

  • SriNitya
    SriNitya
    edited March 29 Answer ✓
    Options

    ILYAS
    Hi,
    Text - Time Period → Use FINDITEM.
    FINDITEM(TIME, Text) Format line Item as Time Period: Quarter.
    let me know if it helps.

  • EXART
    EXART
    Answer ✓
    Options

    Yes it works thank you so much

Categories