oldest

Hi all, I’m using Excel 2013. I swear my VBA code used to work on pivot tables under Excel 2010, but it hasn’t worked for a few months now. We use a year/month code in our database. It’s not a ‘date format’. It’s actually treated as a text field. The month code for March 2014 would be...

Morning, I've been trying to figure this out for days now and I'm getting nowhere fast and no matter how much googling I do I just can't find something that does what I need. I have a very basic worksheet, albeit with 200 rows, that includes names and the dates that their contracts are due to...

I have a spreadsheet containing data drawn from an access database. I want to sort by the date column, which is in dd/mm/yyyy format however I dont have the oldes/newest option on my sort menu. I tried to set the date to general format and found some of the dates returned as numbers i.e. 40656...

Hi All, I am a bit of a novice when it comes to excel. And can't seem to get this part of a project to work correctly. What I am trying to do is find the oldest, second oldest and third oldest dates and display the corresponding names from the example spreadsheet below: A...