Join 3,424 readers in helping fund MetaFilter (Hide)

8 posts tagged with excel and dates. (View popular tags)
Displaying 1 through 8 of 8. Subscribe:

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.
posted by rebent on Aug 26, 2013 - 6 answers

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]
posted by smirkyfodder on Oct 15, 2012 - 2 answers

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]
posted by aggienfo on Aug 6, 2012 - 5 answers

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]
posted by willnot on Jan 30, 2012 - 6 answers

Excel Wizardry Needed

Excel question: How can I tally by quarter when all I have are dates? Bonus challenge details inside. [more inside]
posted by unannihilated on May 9, 2011 - 5 answers

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]
posted by TeachTheDead on Mar 25, 2011 - 9 answers

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]
posted by M.C. Lo-Carb! on Jul 8, 2009 - 8 answers

How do I COMPLETELY turn off Excel autoformatting?

How do I completely turn off all autoformatting in Excel? [more inside]
posted by EndsOfInvention on Sep 28, 2006 - 6 answers

Page: 1