Spreadsheet: 779570d1651858202-nested-if-formula-to-return-value-based-on-date-but-stop-after-12-quarters-example
Sheet: 5.2 Revenue Outputs - FY Realiz

REVENUE OUTPUTS - REALIZED REVENUE (QUARTERLY)
 | Est. Launch Date: | 2023-05-30 00:00:00
 | Realized Revenue (Months): | 2
 | Realized Revenue (Days):
 | Realized Revenue Start Date (Est. Launch Date + Realized Revenue):
QUARTERLY SUMMARY
3-Year Revenue (Not FY) |  | TOTAL Revenue | Recurring Rev (of total) | Implementation Rev | License Rev | TEMS Rev | Accelerator Rev | Product Wins | Product Targets | Accelerator Wins | Accelerator Targets
Year 1 | Q1 | 1076000 | 0 | 396000 | 155000 | 424999.9999999999 | 100000 | 5 | 25 | 5 | 25
 | Q2 | 1421000 | 0 | 536000 | 195000 | 549999.9999999999 | 140000 | 7 | 35 | 7 | 35
 | Q3 | 2594000 | 0 | 1019000 | 245000 | 1050000 | 280000 | 14 | 70 | 14 | 70
 | Q4 | 2901000 | 0 | 801000 | 465000 | 1275000 | 360000 | 18 | 90 | 18 | 90
Year 2 | Q1 | 3442000 | 579999.9999999998 | 1077000 | 570000 | 1575000 | 220000 | 12 | 60 | 10 | 50
 | Q2 | 4492000 | 744999.9999999998 | 1447000 | 710000 | 2025000 | 310000 | 16 | 80 | 14 | 70
 | Q3 | 7868000 | 1435000 | 2493000 | 1200000 | 3575000 | 600000 | 30 | 150 | 28 | 140
 | Q4 | 9572000 | 1540000 | 3092000 | 1510000 | 4200000 | 770000 | 39 | 195 | 36 | 180
Year 3 | Q1 | 7334000 | 2015000 | 2034000 | 1310000 | 3625000 | 365000 | 20 | 60 | 16 | 80
 | Q2 | 9849000 | 2845000 | 2749000 | 1705000 | 4874999.999999999 | 519999.9999999999 | 27 | 80 | 23 | 115
 | Q3 | 16604000 | 4785000 | 4614000 | 2925000 | 8125000 | 940000 | 51 | 150 | 43 | 215
 | Q4 | 20436000 | 5879999.999999997 | 5736000 | 3570000 | 9950000 | 1180000 | 67 | 195 | 54 | 270
Total Yr 1
Total Yr 2
Total Yr 3
Total 3-Year
 |  | True | True | True | True | True | True
FY QUARTERLY SUMMARY |  |  |  |  | << In cell following the cell with the first value, input the following formula & drag down through row 51 and across through column O: IFERROR(INDEX(C$11:C$22,MATCH(C12,C$11:C$22,0),1),0)
Qtr/FY | FY Period Start Date | Period Start | Period End | Falls into Qtr? | FY Quarterly Total Revenue | FY Quarterly Recurring Rev | FY Quarterly Implementation Rev | FY Quarterly License Rev | FY Quarterly TEMS Rev | FY Quarterly Accelerator Rev | FY Product Wins | FY Product Targets | FY Accelerator Wins | FY Accelerator Targets | Product/ Accelerator [NAME] (incl. [NAME] length)
FY23 Q1 | 2022-07-01 00:00:00 | 20220701 | 20220930 |  |  |  |  |  |  |  |  |  |  |  | 2022-03-31 18:00:00
FY23 Q2 | 2022-10-01 00:00:00 | 20221001 | 20221231 |  |  |  |  |  |  |  |  |  |  |  | 2022-07-01 18:00:00
FY23 Q3 | 2023-01-01 00:00:00 | 20230101 | 20230331 |  |  |  |  |  |  |  |  |  |  |  | 2022-10-01 18:00:00
FY23 [NAME] | 2023-04-01 00:00:00 | 20230401 | 20230630 |  |  |  |  |  |  |  |  |  |  |  | 2022-12-30 18:00:00
FY24 Q1 | 2023-07-01 00:00:00 | 20230701 | 20230930 |  |  |  |  |  |  |  |  |  |  |  | 2023-03-31 18:00:00
FY24 Q2 | 2023-10-01 00:00:00 | 20231001 | 20231231 |  |  |  |  |  |  |  |  |  |  |  | 2023-07-01 18:00:00
FY24 Q3 | 2024-01-01 00:00:00 | 20240101 | 20240331 |  |  |  |  |  |  |  |  |  |  |  | 2023-10-01 18:00:00
FY24 Q4 | 2024-04-01 00:00:00 | 20240401 | 20240630 |  |  |  |  |  |  |  |  |  |  |  | 2023-12-31 18:00:00
FY25 Q1 | 2024-07-01 00:00:00 | 20240701 | 20240930 |  |  |  |  |  |  |  |  |  |  |  | 2024-03-31 18:00:00
FY25 Q2 | 2024-10-01 00:00:00 | 20241001 | 20241231 |  |  |  |  |  |  |  |  |  |  |  | 2024-07-01 18:00:00
FY25 Q3 | 2025-01-01 00:00:00 | 20250101 | 20250331 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-01 18:00:00
FY25 Q4 | 2025-04-01 00:00:00 | 20250401 | 20250630 |  |  |  |  |  |  |  |  |  |  |  | 2024-12-30 18:00:00
[NAME] | 2025-07-01 00:00:00 | 20250701 | 20250930 |  |  |  |  |  |  |  |  |  |  |  | 2025-03-31 18:00:00
[NAME] | 2025-10-01 00:00:00 | 20251001 | 20251231 |  |  |  |  |  |  |  |  |  |  |  | 2025-07-01 18:00:00
[NAME] | 2026-01-01 00:00:00 | 20260101 | 20260331 |  |  |  |  |  |  |  |  |  |  |  | 2025-10-01 18:00:00
FY26 Q4 | 2026-04-01 00:00:00 | 20260401 | 20260630 |  |  |  |  |  |  |  |  |  |  |  | 2025-12-30 18:00:00
FY27 Q1 | 2026-07-01 00:00:00 | 20260701 | 20260930 |  |  |  |  |  |  |  |  |  |  |  | 2026-03-31 18:00:00
FY27 Q2 | 2026-10-01 00:00:00 | 20261001 | 20261231 |  |  |  |  |  |  |  |  |  |  |  | 2026-07-01 18:00:00
FY27 Q3 | 2027-01-01 00:00:00 | 20270101 | 20270331 |  |  |  |  |  |  |  |  |  |  |  | 2026-10-01 18:00:00
FY27 Q4 | 2027-04-01 00:00:00 | 20270401 | 20270630 |  |  |  |  |  |  |  |  |  |  |  | 2026-12-30 18:00:00
FY28 Q1 | 2027-07-01 00:00:00 | 20270701 | 20270930 |  |  |  |  |  |  |  |  |  |  |  | 2027-03-31 18:00:00
FY28 Q2 | 2027-10-01 00:00:00 | 20271001 | 20271231 |  |  |  |  |  |  |  |  |  |  |  | 2027-07-01 18:00:00
FY28 Q3 | 2028-01-01 00:00:00 | 20280101 | 20280331 |  |  |  |  |  |  |  |  |  |  |  | 2027-10-01 18:00:00
FY28 Q4 | 2028-04-01 00:00:00 | 20280401 | 20280630 |  |  |  |  |  |  |  |  |  |  |  | 2027-12-31 18:00:00
FY | Total Revenue | Total Recurring Rev | Total Implementation Rev | Total License Rev | Total TEMS Rev | Total Accelerator Rev | Total Product Wins | Total Product Targets | Total Accelerator Wins | Total Accelerator Targets
FY23
FY24
FY25
FY26
FY27
FY28
Total
Validations