Jan 22, 2025 05:46 AM
Hi everyone,
I desperately need help as this formula is driving me crazy! Basically the formula works except for Jan - Feb and March 25 and shows them as Q2 24 instead of Q$ 24.
This is the fiscal breakdown
Here is the formula:
Solved! Go to Solution.
Jan 22, 2025 04:35 PM
Does this look right?
SWITCH(
MONTH(Date),
4, 'Q' & 1 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
5, 'Q' & 1 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
6, 'Q' & 1 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
7, 'Q' & 2 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
8, 'Q' & 2 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
9, 'Q' & 2 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
10, 'Q' & 3 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
11, 'Q' & 3 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
12, 'Q' & 3 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
1, 'Q' & 4 & ' FY' & DATETIME_FORMAT(DATEADD(Date, -1, 'years'), 'YY'),
2, 'Q' & 4 & ' FY' & DATETIME_FORMAT(DATEADD(Date, -1, 'years'), 'YY'),
3, 'Q' & 4 & ' FY' & DATETIME_FORMAT(DATEADD(Date, -1, 'years'), 'YY')
)
Jan 22, 2025 04:35 PM
Does this look right?
SWITCH(
MONTH(Date),
4, 'Q' & 1 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
5, 'Q' & 1 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
6, 'Q' & 1 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
7, 'Q' & 2 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
8, 'Q' & 2 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
9, 'Q' & 2 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
10, 'Q' & 3 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
11, 'Q' & 3 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
12, 'Q' & 3 & ' FY' & DATETIME_FORMAT(Date, 'YY'),
1, 'Q' & 4 & ' FY' & DATETIME_FORMAT(DATEADD(Date, -1, 'years'), 'YY'),
2, 'Q' & 4 & ' FY' & DATETIME_FORMAT(DATEADD(Date, -1, 'years'), 'YY'),
3, 'Q' & 4 & ' FY' & DATETIME_FORMAT(DATEADD(Date, -1, 'years'), 'YY')
)
Jan 23, 2025 01:32 AM
Thank you so much!!!! BLESS YOU.