Function determine if date is even or odd
 

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

Function determine if date is even or odd
 

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!

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