Wolfgang asks how I came up with the birthday formula. While I was tempted to tell him that it was a special secret, I decided I would come clean. Here’s the formula:

=FACT(4)+PV(1,30,28)+MONTH(38166)+SIN(RADIANS(90))+ LEN(“dicksblog”)+CHOOSE(3,10,14,22,36,88)+TRUE

A couple of years ago, a friend of mine sent me an email on my birthday. We had a long email conversation about our impending trip to the Lake of the Ozarks and there was about 20 people on the email distribution list. Some of them starting asking how old I was, and not wanting to tell them, I gave them a formula similar to the one above. Not a single one of them figured that they could put that formula into Excel to get the answer.

Trying to come up with a sufficiently long formula, I “borrowed” some functions from the Excel Clock which I found via JWalk.

This was the best I could come up with for my age. Relatively simple:

=SUM((ROW(A1)^2+(ROW(A2)^2+(ROW(A3)^2+(ROW(A4)^2+(ROW(A5)^2))))))

This is how old I am.

=ROMAN(VALUE(CONCATENATE(SQRT(16),(FALSE))))

Just a bit of a coincidence involved. :-)

dick,

i tried to make your formula work for ME too…

no such luck, of course…

could you give some explanation please and did you use the american date-format as opposed to the european one??

thanx, wolfgang