Function determine if date is even or odd
And make sure you have the analysis toolpak loaded so you can use =iseven().
An alternative that doesn't need the ATP:
=mod(day(a1),2)=0
Gary''s Student wrote:
Let's assume that you mean that the day is even. If the date is in A1 then:
=ISEVEN(DAY(A1)) will return TRUE if the date is even,
--
Gary's Student
"jlewis" wrote:
Is there a function that can determine if a date is even or odd? Thanks!
--
Dave Peterson
|