Excel question: Can I enter just a 1-31 value into one cell and have a complete date appear in a different cell based on fixed month and year values? [more inside]
Probably pretty simple, but I would like to clean up the Metafilter Infodump timestamp, help? [more inside]
I have an Excel spreadsheet I use to track glucose readings. There’s a value diabetics use called “A1C” which looks at the last three months of readings. It's based on a blood test, but can be estimated by averaging your readings for the last three months. I try to track every day, but I can’t reliably say “look at the last 90 values” – so I’m wondering how to set up a formula to tell it to only look at readings going back 90 days, not necessarily 90 readings. More inside. [more inside]
What are the dates for the 9th and 20th business day for the rest of this year and all of next year?
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]
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]
Quick Excel help? Need to retrieve this day last year based on date input by user [more inside]
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]
How can I count certain things in a range of cells in Excel that fall between two dates? [more inside]
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]
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?