Excel Magic Trick 1103: Formulas for Quarters, Fiscal Quarters & Fiscal Years
44.8 هزار بار بازدید -
10 سال پیش
-
Download Excel Start File:
Download Excel Start File: people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1…
Download Excel File: people.highline.edu/mgirvin/ExcelIsFun.htm
Formulas for Quarters, Fiscal Quarters & Fiscal Years:
1. (00:07 min) Quarters using CEILING and MONTH function
2. (02:48 min) Fiscal Quarter using LOOKUP and MONTH (barry Houdini trick!)
3. (05:24 min) Fiscal Quarter using IF, MONTH and CEILING
4. (06:40 min) Fiscal Year using YEAR and Boolean Math
5.
10 سال پیش
در تاریخ 1393/02/04 منتشر شده
است.
44,803
بـار بازدید شده