Excel - Current Run Rate

Asked By Cole on 06-Feb-08 08:17 PM
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).




Tyro replied on 06-Feb-08 08:42 PM
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
Tyro replied on 06-Feb-08 08:45 PM
Correction. If you have a version of Excel 2007 should read: If you have a
version of Excel prior to Excel 2007 ..........

Tyro
Cole replied on 06-Feb-08 09:10 PM
Outstanding! Works great.
Tyro replied on 06-Feb-08 09:31 PM
You're welcome.

Tyro
Tyro replied on 06-Feb-08 10:40 PM
Another formula to determine the number of days in the current month is:

=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))

So with $5000 in A1 and 3 in A2, put
=A1/A2*DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)) will calculate 48333.33

Tyro
T. Valko replied on 06-Feb-08 10:57 PM
Try this:

=DAY(EOMONTH(NOW(),0))

=A1/A2*DAY(EOMONTH(NOW(),0))

--
Biff
Microsoft Excel MVP