Guides
Marketplace

Supported Period Formats

Daloopa's Excel Add-In supports the period formats below. Case does not matter in any format; lowercase and uppercase both work.

Notation key

  • X number
  • Q Q
  • FY FY
  • | or
  • Y one digit of the year
  • E estimate suffix
  • A actual suffix
  • [ ] optional element
  • ( ) required element

Excel date cells

The add-in supports any Excel date format, as long as the cell is formatted as a valid Excel DATE type. It subtracts 45 days from every date and converts it to the classic format. With this type, FY is not supported, and conversion runs only from Q1 to Q4.

Classic format

2021Q1, 2021Q2, 2021Q3, 2021Q4, 2021FY (YYYYQX)

Pattern 1

(XQ | FY | F)["-" | "'" | "_" | ":" | whitespace](YY | YYYY)[whitespace]["E" | "A"]
(QX | FY | F)["-" | "'" | "_" | ":" | whitespace](YY | YYYY)[whitespace]["E" | "A"]

Examples: 2Q22, 2Q 22, 2Q-22, 2Q'22, 2Q:22, 2Q2022, 2Q 2022, 2Q-2022, 2Q'2022, 2Q:2022, 2Q_2022, Q2 22, Q2-22, Q2'22, Q2:22, Q2_22, Q2 2022, Q2-2022, Q2'2022, Q2:2022, Q2_2022

Pattern 2

YY[whitespace]["E" | "A"]
YYYY[whitespace]["E" | "A"]
YYYY["-" | "'" | ":" | whitespace](QX | XQ | FY)[whitespace]["E" | "A"]
YY["-" | "'" | ":" | whitespace](QX | XQ | FY)[whitespace]["E" | "A"]

Examples: 22 (converts to 2022FY), 2022 (converts to 2022FY), 2022Q1, 2022 Q1, 2022-Q1, 2022'Q1, 2022:Q1, 2022_Q1, 22Q1, 22 Q1, 22-Q1, 22'Q1, 22:Q1, 2022 1Q, 2022-1Q, 2022'1Q, 2022:1Q, 2022_1Q, 22 1Q, 22-1Q, 22'1Q, 22:1Q, 22_1Q