| View previous topic :: View next topic |
| Author |
Message |
kocoman
Newbie
Joined: 16 Apr 2005
Posts: 3
|
 Posted: Tue Nov 15, 2005 7:56 pm Post subject: average interval of these 4 dates? |
 |
|
Please tell me how to find out the average interval of these 4 dates? Equation? Thanks
10/23/05
10/27/05
11/03/05
11/11/05 |
|
| Back to top |
|
 |
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Wed Nov 16, 2005 2:03 am Post subject: |
|
|
Dates in col A
B1=A2-A1
drag down
any other cell =AVERAGE(B2:B4)
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
davel
Power User
Joined: 18 Oct 2005
Posts: 62
Location: PA, USA
|
| Posted: Wed Nov 16, 2005 7:35 am Post subject: |
|
|
carl;
you wrote | Quote: | | any other cell =AVERAGE(B2:B4) |
did you mean "any other cell =AVERAGE(B1:B3)" 
Dave L |
|
| Back to top |
|
|
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Thu Nov 17, 2005 12:01 am Post subject: |
|
|
yes
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
|
