I need to know when i enter a formula to calculate(two different years) the
number of years an employee has worked and then i try to divide the
difference the number does not come up like the example in the book. The
example is Ex 90, Figure 2-35.
Example: Subtract cell B13 from B2 then divide the difference by 365. Could
you please email me as soon as possible ) I'm tried
every way for this to come up but it still doesn't work.

Thank You

Crystal

And the name of the book is.......drumroll..........?

Assume Jan 1, 2001 in A1 and today's date(Oct 24, 2005) in A2

Format A3 as a number or general.

In A3 enter =(A2-A1)/365 which returns 4.81369863

See also Chip Pearson's site for info on the DATEDIF Function.


Gord Dibben Excel MVP

On Mon, 24 Oct 2005 12:39:09 -0700, "crystal"
wrote:

I need to know when i enter a formula to calculate(two different years) the
number of years an employee has worked and then i try to divide the
difference the number does not come up like the example in the book. The
example is Ex 90, Figure 2-35.
Example: Subtract cell B13 from B2 then divide the difference by 365. Could
you please email me as soon as possible ) I'm tried
every way for this to come up but it still doesn't work.

Thank You