Excel2007Filter: I want to be able to search information between two things in a single cell in Excel. So a cell may have 4-9 typed in it, but I want that cell to be highlighted if a user searches for 7. Or 4. Or anything between 4 and 9 inclusively. (More details and a screenshot of the spreadsheet inside.) [more inside]
posted by sperose on Sep 2, 2009 - 3 answers

How can I count certain things in a range of cells in Excel that fall between two dates? [more inside]
posted by SansPoint on Sep 2, 2009 - 5 answers

MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today? [more inside]
posted by Rock Steady on Nov 14, 2008 - 13 answers

Excel problem. How do I convert the following number format. 106026 where from left - first digit is CENTURY. Next two are YEAR and last three are JULIAN DAY. So last example is CENTURY 1, YEAR 06, and 26th Julian day of the year. I would like to convert to to mm/dd/yy. Anyone have good Excel-fu for this?
posted by thimk on Jan 26, 2006 - 10 answers