Is there a function that can determine if a date is even or odd? Thanks!
G Gary''s Student Nov 17, 2005 #2 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,
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 Nov 17, 2005 #3 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
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
