Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
crystal
 
Posts: n/a
Default how do i subtract and divide

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
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default how do i subtract and divide

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
subtract year and divide crystal Excel Worksheet Functions 7 October 26th 05 12:52 AM
subtract and divide crystal Excel Worksheet Functions 1 October 24th 05 08:22 PM
how do I subtract years and then divide crystal Charts and Charting in Excel 1 October 22nd 05 07:28 PM


All times are GMT +1. The time now is 03:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"