I work for a company that is converting all of their Lotus 123 (Dos Version
Release 2.2) spreadsheets to Excel.

I do not understand this Lotus formula =AND(A9>=$AA$2,A9<=$AB$2) in cell
AC2.

The "A" column is full of dates.
AA2 has another date January 1, 2005, and AB2 has another date January 31,
2005.

A9 is a dashed line no date or pertinent information. When I can the
formula to A10 which is the first cell with a date the AC2 cell now says true
or false.

I want the formula to look at the whole column and determine which dates are
in between 01-01-05 and 01-31-05. Can someone help me write this formula.

--
bb