Thread: If then syntax
View Single Post
  #4   Report Post  
Joseph
 
Posts: n/a
Default


Try using this formula

=IF(A2=DATE(2005,1,1),IF(A2<=DATE(2005,4,1),1,0))

Where A2 has the Date that you want. Let me know how it goes.

Cheers


--
Joseph
------------------------------------------------------------------------
Joseph's Profile: http://www.msusenet.com/member.php?userid=2505
View this thread: http://www.msusenet.com/t-1870448372