ok so i have 494 data entries. one of the sorting factors is date of birth. now, i want to sort it from months, but evertime i his sort it does it by literal date of birth (age).

how can i change this, without having to enter any more info.

the date is entered: MM/DD/YYYY

just trying to make life a bit easier, but if it doesnt work ill just search manually for the months.

12/3/2007 9:22:09 AM

type them in the order you want, durrrr.



[Edited on December 3, 2007 at 9:24 AM. Reason : but srsly, idk]



[Edited on December 3, 2007 at 9:26 AM. Reason : nvm]

12/3/2007 9:23:24 AM

12/3/2007 9:25:18 AM

make a new column with the function =MONTH(your cell with the date)
sort on the new column

12/3/2007 9:26:51 AM

^ so can that function read the first digit and insert it into another column.

12/3/2007 10:10:26 AM

Just try it, damn. Open excel, insert a couple lines, and try it.

Lazy sons a bitches

12/3/2007 10:16:54 AM

negro please. i did try it.

it worked after a few tweeking

12/3/2007 10:21:00 AM

a single year will have some numerical value. Find this numerical value, multiply by the floor of the date divided by said value, subtract this value from the data

and there you go.

12/3/2007 10:27:52 AM

umm

=month(cell#)

worked perfect.

thanks though

12/3/2007 10:29:32 AM