Is there a function that can determine if a date is even or odd? Thanks!

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!

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