Function determine if date is even or odd

G

Guest

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,
 
D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for odd even numbers 4
Odd and even numbers 6
Even or Odd Year Function 3
2007 Even/Odd/MOD 4
FUNCTION PREDICTING EVEN/ODD COUNT IN QUERY 1
Even or Odd Number 4
Unable to receive OTP codes via o2 6
COUNT question 3

Top