Difference between Financial Year Quarters

[Neha121]

Hi,

   How Do I calculate the difference between two financial quarters?

Column E - Column C = (in number)

example for First row the difference should be 1

[robert_mika · Accepted solution]

(
(Left(FQTR_Transaction, 4) * 4) + Right(FQTR_Transaction, 1)
)
-
(
(Left(FQTR_OCCURRED, 4) * 4) + Right(FQTR_OCCURRED, 1)
)

[Nagaraju_KCS]

Try this!

=Replace(FQTR_Transaction, 'Q','') - Replace(FQTR_OCCURRED, 'Q','')