View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ben simpson
 
Posts: n/a
Default Values and maxiums

I'm soooo lost here. I need a way to reference a hire date (E15) , and if
the date is earlier than July 1st ,1989, allow a maxium of 201 to be
accumulated in U35, but, if the hire date is July 1,1989 or later, allow a
maxium of 120 to be accumulated in U35. I believe my brain just
spontaneously cumbusted on this one......Ouch....Help....Ben