- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 20, 2024 10:42 AM
I have this formula for calculating the quarter and the fiscal year of when an invoice should be paid.
Program Start date is 7-4-2024 (which is Q3). I want it to be paid the quarter after (so this one would be be paid Q4, FY24) but its showing Q3 - FY25. How do I adjust? the formula below for a "Program Start Date" of 7-4-24 to show that it should be paid Q4-FY24?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 21, 2024 09:57 PM
Hmm, so like this?
'Q' &
IF(
ROUNDUP(MONTH({Program Start Date})/3, 0)+1 = 5,
1,
ROUNDUP(MONTH({Program Start Date})/3, 0)+1
) &
" - FY" &
IF(
ROUNDUP(MONTH({Program Start Date})/3, 0)+1 = 5,
25,
24
)
Sorry, I don't think I understand your question!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 20, 2024 07:16 PM
Does this look right? 
'Q' &
IF(
ROUNDUP(MONTH(Date)/3, 0)+1 = 5,
1,
ROUNDUP(MONTH(Date)/3, 0)+1
) &
" - FY" &
IF(
ROUNDUP(MONTH(Date)/3, 0)+1 = 5,
25,
24
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 21, 2024 07:51 AM
close! It has to feed off the program start date though to pull the next quarter to pay. How do I add that it feeds off {program start date}?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 21, 2024 09:57 PM
Hmm, so like this?
'Q' &
IF(
ROUNDUP(MONTH({Program Start Date})/3, 0)+1 = 5,
1,
ROUNDUP(MONTH({Program Start Date})/3, 0)+1
) &
" - FY" &
IF(
ROUNDUP(MONTH({Program Start Date})/3, 0)+1 = 5,
25,
24
)
Sorry, I don't think I understand your question!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 22, 2024 10:39 AM
Thank you Adam!
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)