how do i subtract and divide

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top