Thread: [Solved] Use SMALL or LARGE to find date
View Single Post
 
Old 05-01-2011, 03:08 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi udea,

If you apply the same cell formatting that you're using in the date cells to the cell containing the LARGE/SMALL formula, the results will appear as dates.

Alternatively, for the dates you gave:
=TEXT(LARGE(A1:A9,2),"d/mm/yyyy")
will return a formatted date for the value ranked as the second-largest. Using LARGE on its own returns the date's serial number.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote