Hi Bernie, thanks so much for your excellent assistance. I am having a
minor trouble getting your formula to work. It may be the way I copied
it into the workbook. In cell AR3 where I first copies your formula,
the results of either True or False do not appear in that cell (the cell
is blank). Cell X3 is showing text: "VACANT" and cell AQ3 has the date
01 Dec 09 in it. I do not understand why cell AR3 is blank?
Would it be possible for you to please explain in general terms (I am a
newbie) why column AS is not populated with your formula? Also, do we
need cell AX1 to be populated by the number zero?
I am trying to understand as best I can your formula so that I may learn
more about Excel formulas.
Again, I thank you. It is sometimes not easy to understand what people
need when replying back to their Excel problems. Thanks for your
understanding and patience.
Kind regards,
Chris.
*** Sent via Developersdex
http://www.developersdex.com ***