Function in Excell

[Simple]

Hi, I'm writing a worksheet but need help with the
following functions please.
Cell C1 has a date function written as 15/07/2002 (date
of installation)
Cell C4 has a meter reading from a photocopier ie 270989
Question: In cell C5 I want to put the average monthly
volume (meter reading divided by the amount of months
since the machine was installed) how do i accompliss this
funcion automactically? In the above example the cell C5
would have a function of 270989/24 = 11291.
As you have probably quessed I'm a newbie to Excell
Many thanks Simple

 

[Michael Malinsky]

In C5:

=C4/(DAYS360(C1,NOW())/30)

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Frank Kabel]

Hi
try
=C4/DATEDIF(C1,TODAY(),"m")

 

[Wing Tsun]

Simple:

You can try the following function. Hope that is what you want.

ColumnB Column C
=======================================
Row1|| Installed Date: July 15, 2002
Row2|| Present Date: =TODAY()
Row3|| # of Months: =(YEAR(C2)-YEAR(C1))*12+MONTH(C2)-MONTH(C1)
Row4|| Usage: 270989
Row5|| Average Usage: =C4/C3

you need to format Cell C1 as Date, C4 as Numbers

Wing Tsun