Re: Current Run Rate

Tech-Archive recommends: Fix windows errors by optimizing your registry

If you have a version of Excel 2007 and have the Analysis Toolpack installed
or have Excel 2007, to determine the number of days in the current month you
can use:
=EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0)
So if your $5000 is in A1 and your 3 is in A2 in A3 put:
=A1/A2*(EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0)) to calculate
$48333.33 for February.

Tyro

"Coley" <Coley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:55C11C4C-72CB-4446-8B57-16DCE919295C@xxxxxxxxxxxxxxxx
I am trying to calculate the current sales rate. If I have $5000 in sales
after 3 days ($1666.67/day) I want to show $48333.33 for the current
monthly
rate (Feb 29th).


.