I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion. [more inside]
posted by reenum
on Sep 14, 2012 -
Excel question: I'm making a calendar/schedule in Excel, and I have the dates (numbers) aligned in the bottom right corner. I want to add information and text, though, starting in the top left corner. How do I do this? [more inside]
posted by zardoz
on Aug 31, 2011 -
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 -
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 -
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 -