# 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```