Text to quarter ?

ILYAS
ILYAS
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 ✓

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

  • ILYAS
    ILYAS
    Answer ✓

    Yes it works thank you so much

Categories