ComplyRight Fiscal Year Attendance Calendar Kit, 2017-2018, 50 Pack

hey this is Chrisman art I had a great question from a CPA I was training they wanted to know how much money was made every quarter in a year and I told them they can do a pivot table and quickly figure it out and they said the issue is they're on a fiscal year that runs from July to June they're not January through December so if you want to know the quarter anyway without using a pivot table I've shown this before the month function I should get the number four here will always pull the month out of invoice date or order date and as you can see it's working so then what you do is you combine it with the round function and I'm gonna round up the month so you know I'm gonna get the number four right here I'm gonna divide 4 by 3 because there's three months and a quarter so 4 divided by 3 is 1.33 and since this rounding up is going to give me the number 2 and I want to see zero digits so