Calculate A Calendar Or Fiscal Quarter From A Date

 
Published on June 14, 2017
Channel: Doug H
Category: Education
Source: Youtube

Do you need a formula to calculate a fiscal month, quarter or year from a date field? If your organization has the fiscal months or quarter starting in January, that's fairly easy to do. However if your company has the fiscal year start in August, that makes it a bit more challenging. But it's not too hard to do. Just add a couple of CHOOSE, MONTH and YEAR (along with IF) functions together and you'll get a solution. Check out the video to see the magic... P.S. Feel free to provide a comment or share it with a friend! ------------------------------------------------------------------------------------------------- Subscribe to the Blog: http://myexcelcharts.blogspot.com