Years of service...

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 <E3019F83-5BD9-4355-9053-5EE82D6010BE@microsoft.com>,
"Kane" <Kane@discussions.microsoft.com> 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 <E3019F83-5BD9-4355-9053-5EE82D6010BE@microsoft.com>,
> "Kane" <Kane@discussions.microsoft.com> 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 <at>yahoo<dot>com
----
"Kane" <Kane@discussions.microsoft.com> wrote in message
news:F67D6636-176A-4209-9C95-1F79F9179ED8@microsoft.com...
> 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 <E3019F83-5BD9-4355-9053-5EE82D6010BE@microsoft.com>,
> > "Kane" <Kane@discussions.microsoft.com> wrote:
> >
> > > How would I determine years of service.... example is September 01,
1989?
> >