Calculate Financial Quarter from a date
Posted on 2011-10-19
I want to know if there is a simpler way to calculate the Financial Quarter
Sorry to add another question on this topic but I failed to find a simple answer which would work for any date (happy to be redirected). I don't want to write out a special table manually but to work it out mathematically.
The quarter "1" is Jul - Sep, "2" is Oct - Dec, etc
The following returns what I want, but idealy I would not use the IF() statement, and only reference the date cell once if possible.
The simplest/shortest solution using vba or excel formula.