how do i subtract and divide

C

crystal

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 ([email protected]) I'm tried
every way for this to come up but it still doesn't work.

Thank You
 
G

Gord Dibben

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
 
Top