View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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!