Excel Choose & Month function for Quarters where fiscal year is not calendar year - Chris Menard

preview_player
Показать описание
UPDATED Video on the CHOOSE Function

If you need to find the quarter in Excel you can use the Roundup and Month functions. You can also just use a PivotTable. The issue is when the fiscal year is not the same as the calendar year.
Then you need to use Choose and Month functions.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Рекомендации по теме
Комментарии
Автор

Awesome sauce! Thank you! I thought your explanation was spot on!!

stephaniehutcheson
Автор

Do you know of a formula that can extract the month name from a date based on the fiscal year?

williamholesapple
Автор

Would be a good video if it had a thorough explanation.

ericerickson