How would I determine years of service.... example is September 01, 1989?

One way:

=DATEDIF(A1,TODAY(),"y")


See

http://cpearson.com/excel/datedif.htm

In article ,
"Kane" wrote:

How would I determine years of service.... example is September 01, 1989?

JE...
I would like to present a blank cell in "L46" if there is no Anniversary
date entered in "D46"
different examples;

D46: Anniversary Date ... MM/dd/yy
H46: =IF(D46="","",DATEDIF(D46,TODAY(),"Y"))
L46: =SUM(N5:N19)/H46

Now what?

"JE McGimpsey" wrote:

One way:

=DATEDIF(A1,TODAY(),"y")


See

http://cpearson.com/excel/datedif.htm

In article ,
"Kane" wrote:

How would I determine years of service.... example is September 01, 1989?

Think you could try in L46:

=IF(OR(H46="",SUM(N5:N19)=0),"",SUM(N5:N19)/H46)

The above will return a blank in L46
if either: H46 ="", or SUM(N5:N19)=0
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Kane" wrote in message
...
JE...
I would like to present a blank cell in "L46" if there is no Anniversary
date entered in "D46"
different examples;

D46: Anniversary Date ... MM/dd/yy
H46: =IF(D46="","",DATEDIF(D46,TODAY(),"Y"))
L46: =SUM(N5:N19)/H46

Now what?

"JE McGimpsey" wrote:

One way:

=DATEDIF(A1,TODAY(),"y")


See

http://cpearson.com/excel/datedif.htm

In article ,
"Kane" wrote:

How would I determine years of service.... example is September 01,
1989?