On 2002-10-16 13:57, RichardDK wrote:
Unfortunately, it is stored as serial number e.g. 11,720.
From an employee birth-date spreadsheet, I want to sort and find out which employee is having a birthday in November.
Can it be done?
On 2002-10-16 14:03, paliman wrote:
Say the dates you want to sort are on col.A
In B2 type and copy down
=MONTH(A2)
Then you can sort on this new column or use an autofilter to view your results
If your list consists of multiple years format your date values as "mmm", choose the Data | Sort... menu command, click on [ Options... ], and choose "Jan, Feb, Mar..." as your sort key.