Thank you Biff.

I understand what a "computer geek" is and I take it as a compliment.

I missed the "date" part. Let me tell you this. In the past, I didn't even say DATEDIF correctly. I thought it was DATED-IF. One day, I realized its role, and from then I knew it should be

DATE-DIF(ference)

Now, it is easy for you to understand how I missed "date" as in "dating." I did tell you sometimes I have a unique way of interpreting things.

I am surprised about one thing. The poster doesn't frequent this board; at least the name is not familiar to me. Looks like his post in my thread is the only post??? Sometimes, I am concerned about the kind of attention that I am drawing. ;)

Epinn

"Biff" wrote in message ...
Translation:

The observation your posted is one that only a true "computer geek" could
appreciate. Geeks are known to be nerds who have trouble getting "dates"
with the ladies/men. In this case, "dates" is a play on DATEDIF.

Biff

"Epinn" wrote in message
...
Don't understand what you are trying to say. Can you rephrase that please?

Epinn

"David F Cox" wrote in message
...
Not for nothing do geeks have a reputation for having problems with dates :)

"Epinn" wrote in message
...
My discovery on DATEDIF ("yd") and leap year

A1:A4

2/1/2007
3/1/2008
2/1/2008
3/1/2009


formula (1) =DATEDIF(A1,A2,"yd") yields 28

formula (2) =DATEDIF(A3,A4,"yd") yields 29

I understand why this is happening - the year for the first argument is
used.

I find DATEDIF and "yd" and leap year "interesting," "temperamental,"
"confusing," ...... <g

I am curious if "yd" is used often.

Welcome comments to this and my discovery.

Epinn