Solved Excel 2003 if and formula

June 2, 2011 at 17:50:13
Specs: Windows XP
In my spreadsheet I have 17 cells in a row. If I enter a certain date in cell 1 a text string will appear in one of the other 16 cells, if the date in cell 1 is within a certain date range. How can I make the text string that appears in any one of the cells in the row of cells appear in a cell at the end of the row? The formula is the same in each cell accept for the date range: =IF(AND(C8>=DATE(2011,6,21),C8<=DATE(2011,7,4)),"Period 6 and 7 are 196 hours credit each period","")

See More: Excel 2003 if and formula

Report •

June 2, 2011 at 21:47:59
✔ Best Answer
Would something like this work?


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

June 3, 2011 at 11:24:01
The formula you provided worked perfectly.

Thank you

Report •

Related Solutions

Ask Question