Forum Discussion
Re: Sorting
Let's say the birth dates are in D2:D100.
Insert a column to the right of column D. Enter the following formula in E2, then fill down:
=TEXT(D2, "mmdd")
Sort the entire range on column E.
1 Reply
- Great! Thanks.
Let's say the birth dates are in D2:D100.
Insert a column to the right of column D. Enter the following formula in E2, then fill down:
=TEXT(D2, "mmdd")
Sort the entire range on column E.
