Sometimes, I am concerned about the kind of attention that I am drawing.
;)

Well, it's better than getting flamed by some of the idiots in other places,
isn't it?

Ask all the questions you like. How else will you learn? I'm not an expert
but I do know a thing or two about Excel and most of what I know I learned
right here. Invest some time here and before you know it you'll be answering
the questions rather than asking the questions.

Biff

"Epinn" wrote in message
...
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