Hi David

Just tried it again and it returns 62 up to 10 Oct 1944 and 61
thereafter.
Not consistent with what I was seeing before.

I set up a table of dates from 30/09/44 through 11/11/44 down column A,
then filled through for 12 columns so I have from 30/09/44 to 11/11/56.
Copied the formula across as appropriate and then switch from 1 year to
one lower year seems to occur after 11/10 for years 44 and 45, 12/10 for
year 46 and 47, back to 11/10 years 48 and 49 and continues this pattern
of switching after every pair of years

It must be something to do with leap year and Rounding in Excel's
calculation.

I'm not going to give it any more thought!!!!

I have long since discovered that there is no foolproof method of
consistent calculation of date intervals other than the straight
subtraction of one date from another and returning the number of days.

"Sod" was obviously alive and well when our planetary system was formed
giving rise to a cycle around the Sun that is not an exact number of
days, let alone weeks and with a calendar devised which incorporates
such a disparate set of day ranges, how on earth can anyone expect to
get it right<vbg

--
Regards

Roger Govier


"David Biddulph" wrote in message
...
I see what you mean, but are you sure that it's all dates in October,
and not just yesterday (11th Oct)? Doesn't 9/10/44 or 10/10/44 give
62?

I get the impression that we may just be a day adrift for some years,
and my guess is that it's tied up with leap years, but you're right
that my simple formula isn't 100% reliable. Thanks for pointing it
out.
--
David Biddulph

"Roger Govier" wrote in message
...
Hi David

Don't know what's going on here.
When I enter 11/10/1944 in A1
=YEAR(TODAY()-(A1))-1900
returns 61
30/09/1944 returns 62
but all October dates return 61
--
Regards

Roger Govier

"David Biddulph" wrote in message
...
"Roger Govier" wrote in message
...
"David Biddulph" wrote in message
...
"Roger Govier" wrote in message
...
...
If you only want the number of years, then you were almost there
with your formula
=YEAR(TODAY())-YEAR(A1)
where A1 is holding the birthdate.
You need to format the cell with the formula as General
FormatCellsNumberGeneral otherwise an age of say 44 would show
as 13/02/1900

That would give the age which will be achieved by the end of this
year, rather than the more usual usage which is the number of
whole years already achieved by today's date, which you could get
by
=YEAR(TODAY()-(A1))-1900
(formatted as number with no decimal places).

Hi David

You are absolutely correct. I had tested using my own birthday,
which has already occurred this year.
However, your formula will also give the wrong result when the
month today() is the same as the month(birthday)

You've confused me there, Roger. I can't see why that should be the
case (as the calculation of the month doesn't come into my formula),
and when I test it with birthdays in October it shows the age
changing for dates on or before 12th October, as I would expect.

The only situation where I can foresee that there might be a
difficulty is around leap years, with the question of when someone
born on 29th Feb celebrates their birthday (without resorting to the
Pirates of Penzance!).
--
David Biddulph