Formula to calculate fiscal quarter

Formula to calculate fiscal quarter

Hello!

I am trying to create an IF statement to show the federal fiscal quarter an event occurred. Could someone please help troubleshoot my syntax?

Federal Quarters:

Q1: Oct, Nov, Dec (10, 11, 12)

Q2: 1, 2, 3

Q3: 4, 5, 6

Q4: 7, 8, 9


Not working syntax

=IF(MONTH([6m NOMs Date]@row) = >10, 1, IF(MONTH([6m NOMs Date]@row) < 3, 2, IF(MONTH([6m NOMs Date]@row) = >7, 4, IF(MONTH([6m NOMs Date]@row) = >4, 3))))



Thanks!

Best Answer

Answers

Sign In or Register to comment.