Sort dates by a formula

Hi,
I need to sort dates with a formula. I have a list of dates and corresponding areas and want the dates sorted (oldest to newest) in column F (please see attached example file). I would like the corresponding area numbers to sort along with the dates so that they still align.
What formula would I use and what cell/s would it go in?
Thanks very much
Dave

You don't need a formula. Providing you select the entire dataset before you sort, all the columns should be included and sorted correctly.

You can use this formula in F3:

=SMALL($B$3:$B$17,ROWS($1:1))

and this one in G3:

=VLOOKUP(F3,$B$3:$C$17,2,0)

then copy down as required.

Note that this will not work properly if you have duplicate dates.

Hope this helps.

Pete