View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 60
Default 5 months prior to date macro help please

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 ***