G Guest 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
