=IF(AND(A2C1,A2<D1),"Due","")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Darin Kramer" wrote in message
...


Hi There.
Row 1 contains date information - the last fri in a month. Eg
Cell b1 is 3 Nov.
Cell c1 is 10 Nov
Cell d1 is 17 nov etc

In say A2 there will be a variable date - say 12 Nov
I need a formulae that will put the word DUE in cell d2 (as 12 Nov is
10 Nov, but < 17 Nov...

Any ideas...?
(dont have to worry about excluding weekends!)

Thanks!!!!!!
Regards

Darin



*** Sent via Developersdex http://www.developersdex.com ***