Excel Magic Trick 1103

Formulas for Quarters, Fiscal Quarters & Fiscal Years

DESCRIPTION

Formulas for Quarters, Fiscal Quarters & Fiscal Years:
(00:07) Quarters using CEILING and MONTH function
(02:48) Fiscal Quarter using LOOKUP and MONTH
(05:24) Fiscal Quarter using IF, MONTH and CEILING
(06:40) Fiscal Year using YEAR and Boolean Math

WORKBOOKS

Download “Excel Magic Trick 1101-1120” Excel-Magic-Trick-1101-1120.zip – Downloaded 88 times – 2 MB




Be the first to comment

Leave a Reply