R
R.S.Lynn
On August 27 of this year, I posted a question of how, given a sheet sorted
on date of birth, to display simply the integer number of years of age. Two
approaches were offered, both of which were completely on point and gave me
a solution. ( 1.) Custom cell type yy, and (2). using the semisecret
function datedif(A1,today(),"y"). Both were completely satisfactory, and
gave the desired result. But subsequently, I wanted to prepare my aged
father, 92 years old this month, a list of his relatives and their in-laws
(they number > 100) sorted by birthday anniversary. I prepared three
columns ; mo, day, yr, by simply custom typing them mm,dd,and yy. But when
I sort on these columns, I find that they all contain simply the date of
birth data. Only the display is changed by custom typing. So I have four
columns which fundamentally contain the same data, but which are displayed
differently. When I try to sort on month, for example, I am just sorting on
date of birth, not month of birth. I want to display a sheet sorted by
birthday anniversary.
I presume that my solution lies in creating a column which contains just the
month of birth, and another which contains just the day of the month. I can
think of other possibilities, but this is salient in my mind. If I can
achieve these columns, I can go on from there.
Please suggest formulas of making, e.g., cell D2 contain just the month of
birth contained in the cell C2 --the date of birth -- and E2 contain the day
of the month of birth contained in C2. As I have noted, forcing the display
to be just the month, etc, has already been solved. I need the cell
contents to be just the month, and day of month. Or maybe there are
multiple approaches to sorting on anniversary of birth. Anything that
works.
on date of birth, to display simply the integer number of years of age. Two
approaches were offered, both of which were completely on point and gave me
a solution. ( 1.) Custom cell type yy, and (2). using the semisecret
function datedif(A1,today(),"y"). Both were completely satisfactory, and
gave the desired result. But subsequently, I wanted to prepare my aged
father, 92 years old this month, a list of his relatives and their in-laws
(they number > 100) sorted by birthday anniversary. I prepared three
columns ; mo, day, yr, by simply custom typing them mm,dd,and yy. But when
I sort on these columns, I find that they all contain simply the date of
birth data. Only the display is changed by custom typing. So I have four
columns which fundamentally contain the same data, but which are displayed
differently. When I try to sort on month, for example, I am just sorting on
date of birth, not month of birth. I want to display a sheet sorted by
birthday anniversary.
I presume that my solution lies in creating a column which contains just the
month of birth, and another which contains just the day of the month. I can
think of other possibilities, but this is salient in my mind. If I can
achieve these columns, I can go on from there.
Please suggest formulas of making, e.g., cell D2 contain just the month of
birth contained in the cell C2 --the date of birth -- and E2 contain the day
of the month of birth contained in C2. As I have noted, forcing the display
to be just the month, etc, has already been solved. I need the cell
contents to be just the month, and day of month. Or maybe there are
multiple approaches to sorting on anniversary of birth. Anything that
works.