##
10 posts tagged with date *and* excel.

Displaying 1 through 10 of 10. Subscribe:

## EXCEL: filling a cell with a complete date based on just the day?

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]

## Cleaning up timestamp information in Metafilter Infodump

Probably pretty simple, but I would like to clean up the Metafilter Infodump timestamp, help? [more inside]

## How to Tell Excel to Evaluate Last Three Months (NOT Last 90 Entries)

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]

## How do I get two different justifications in an Excel cell?

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]

## Excel lookup same day different date previous year

Quick Excel help? Need to retrieve this day last year based on date input by user [more inside]

## Searching data within an Excel cell.

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]

## ExcelFilter: Between Day 1 and Day 90, I had how many of which?

How can I count certain things in a range of cells in Excel that fall between two dates? [more inside]

## Excel date arithmetic problem

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-fu needed.

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?

Page:
1