##
9 posts tagged with excel *and* dates.

Displaying 1 through 9 of 9. Subscribe:

## Spreadsheet - Naming calendar quarters with custom date

I'm struggling to do something in a spreadsheet (I'm using Google Spreadsheets, but could use Mac Excel or Numbers if needed). I want to automatically fill one cell with the name of the calendar quarter (e.g. "Q3-2015") based on a user-entered date in another cell. To make it more complicated, the "quarters" don't begin/end on standard dates. [more inside]

## Excel imported my dates as day-month instead of year-month. How to fix?

How do I fix this? I "imported" a table from a PDF (big mistake). In the pdf, the dates were formatted as AA-BB, where AA was the month and BB was the year. Excel interpreted that as AA is the month and BB is the day, and gave them all 2013 as the year. So now the date reads as 11-Jan instead of Jan 2011. I no longer have access to the original dataset because I only just noticed the mistake. I am using Excel 2010 on Windows.

## How to Highlight All Cells Containing Future Date in Excel 2007

In Excel 2007, is there a way to highlight all cells within a certain range (in my case, five adjacent columns) that contain dates in the future? [more inside]

## Work Pivot Table Magic...

Excel Pivot Table Help - My google-fu and excel-fu have failed me, I'm working on a tracking pivot table that will display total number of attendants in a class (broke out in gender) for each day based on a start and end date. [more inside]

## How can I force Relative Cell References into a Conditional Formatting Forumual in Excel

In Excel I have 2 columns with dates in them. D1:D20 Start Date G1:G20 End Date. I want to highlight the cell in the range G1:G20 if the date is more than 14 days form the date in D1:D20. Obvious answer is conditional formatting, but I can't seem to create a formula with relative cell references. [more inside]

## Excel Wizardry Needed

Excel question: How can I tally by quarter when all I have are dates? Bonus challenge details inside. [more inside]

## EXCEL Vs. Time Left

Excel Question! I have two dates on my spreadsheet. How can I accurately determine (retrieve) the time remaining on a warranty date. [more inside]

## Can I remove serial number information from dates in Excel?

I have an excel file with a column of dates, in the xx/xx/xxxx format. I would like to strip out the month and day information, so I could just have a column that shows the year, but excel's method of representing dates as serial numbers has foiled every attempt. Any ideas? [more inside]

## How do I COMPLETELY turn off Excel autoformatting?

How do I completely turn off all autoformatting in Excel? [more inside]

Page:
1