Formula to count how many different months based on employee

[Cityscape123]

Hi

I am trying to find out a formula to input a number if the employee has been absent on particular months. Please see attachment, the last column “Result” should be populated as follows:

If employee absent in April and May and/or June = 2
if only absent in April = 1
if only absent in May and/or June = 2



Thanks

[Cityscape123]

This has been resolved so please ignore, thank you.