Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can I drag down dates with AM and PM?

  1. 22/11/2011 AM
  2. 22/11/2011 PM
  3. 23/11/2011 AM
  4. 23/11/2011 PM

like that?

share|improve this question
Don't think it's possible, personally i would create 2 columns (1xAM, 1xPM) then merge them together and then sort. – HaydnWVN Nov 22 '11 at 12:33
up vote 3 down vote accepted


  1. Type your starting date in cell A1 but don't type 'AM' - a date without a time in Excel is effectively 12:00 AM.
  2. Apply a custom number format dd/mm/yyyy AM/PM to cell A1.
  3. In cell A2 enter the formula =A1+0.5 which is effectively 12:00 PM on the same date.
  4. Now you can drag down from A2 and you'll get the sequence you want.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.