Greetings



Could someone please explain how the formula below works

=MOD(MONTH(A$2),2)<>0

Regards

Rich

Month returns a number from 1 to 12
MOD returns the remainder after a number is divided by a divisor which in this case is 2
The formula will thus return TRUE for odd months and FALSE for even months

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks Pecoflyer

What is the <>0

Thank you

Rich

It means "not equal to" zero

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post