Hello,
A formula I am trying to use:
=IF(A2<>0, MAXIFS('Current 6 months'!J:J, 'Current 6 months'!A:A, A2)+MAXIFS('Previous 6 months'!J:J, 'Previous 6 months'!A:A, A2), "")
Is returning weird results.
It has to look over two sheets and return the latest absence start date from column J
-...