Current Run Rate
 

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).

Current Run Rate
 

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" wrote in message
...
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).

Current Run Rate
 

Correction. If you have a version of Excel 2007 should read: If you have a
version of Excel prior to Excel 2007 ..........

Tyro

"Tyro" wrote in message
t...
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" wrote in message
...
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).

Current Run Rate
 

Outstanding! Works great.

"Tyro" wrote:

Correction. If you have a version of Excel 2007 should read: If you have a
version of Excel prior to Excel 2007 ..........

Tyro

"Tyro" wrote in message
t...
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" wrote in message
...
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).

Current Run Rate
 

You're welcome.

Tyro

"Coley" wrote in message
...
Outstanding! Works great.

"Tyro" wrote:

Correction. If you have a version of Excel 2007 should read: If you have
a
version of Excel prior to Excel 2007 ..........

Tyro

"Tyro" wrote in message
t...
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" wrote in message
...
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).

Current Run Rate
 

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


"Coley" wrote in message
...
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).

Current Run Rate
 

to determine the number of days in the current month you can use:
=EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0)

Try this:

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

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

--
Biff
Microsoft Excel MVP


"Tyro" wrote in message
t...
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" wrote in message
...
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).