Current Run Rate

[Coley]

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]

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]

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

Tyro

 

[Coley]

Outstanding! Works great.

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

Tyro

 

[Tyro]

You're welcome.

Tyro

Outstanding! Works great.

 

[Tyro]

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]

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