Formula to Capture Previous, Current, & Next Quarter
I have a spreadsheet with information populated from Jira. Unfortunately it does not contain information like start and finish date, but uses quarters instead.
I am creating a dashboard with pulling reports for Previous, Current, & Next quarter, which I would like to automate.
I've tried a few formulas, but haven't had luck with anything as its not as simple as I would have hoped.
I've arranged my information in the following way which I hope would be a correct format to get started. Are there any suggestions or ideas on how I can identify tasks in the previous, current & next quarter?
The current formula in month finder is:
=IF(AND(TODAY() >= [Month Start]@row, TODAY() <= [Month End]@row), "Current Month", "Not Current Month")
Was hoping I can do somthing similar with Previous, Current and Next Quarter column.
Help Article Resources
Check out the Formula Handbook template!