Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Still Convert Lotus 123 to Excel 2003 | Excel Discussion (Misc queries) |