Calculate Quarters, Fiscal Quarters, Fiscal Years in Excel

Calculate Quarters, Fiscal Quarters, Fiscal Years in Excel

You can download the workbook here to follow along with the Video!

In this video tutorial, we show several ways to Calculate Quarters, Fiscal Quarters, Fiscal Months and Fiscal Years in Excel

1- First of all, we show how you can calculate quarters using two different methods, one using the CHOOSE function and the other one using the CEILING function.
2- Secondly, we show how you can calculate Fiscal Quarters (We assume the Fiscal year starts in April). We show two ways to do it, one using the CHOOSE function and the other one using a combination of IF and CEILING functions.

3- Finally, we show how to calculate Fiscal years.

I hope you like that Tutorial.

Please watch the video and let me know if you have any comments or feedback in the comments section below.

This Video requires you to know how date and Time work in Excel. If you don’t know how date and time work in Excel, you can Always watch my Excel Date and Time MasterClass.

Please share

If you like this post, don’t forget to Share it with your friends on different social media platforms using the share buttons!

Ace your Excel Career by learning how to create Excel Dashboards!

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Abdelrahman Abdou
Latest posts by Abdelrahman Abdou (see all)
It's only fair to share...Share on Facebook
Facebook
0Pin on Pinterest
Pinterest
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin