I'm looking for a formula in excel for:

#(days in month) / (days left in month)

I'm looking for this formula to automatically calculate
our runrate for the month. If I did it manually it would
look like this. Since the days of the month and days left
changes everyday. I'm wondering if this can be possible.

Example- 20(31) / (8) = 77.5 runrate

Jason,

this will give you the days done:
=DAY(TODAY())

this will give you the #days in month
=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))

this will give you days left in the month
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-TODAY()

runrate...
your formula..
#(days in month) / (days left in month)
would be 23 / 8...

i'd try 23/31 = 74% ( or 77% tomorrow :))



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Jason" wrote:

I'm looking for a formula in excel for:

#(days in month) / (days left in month)

I'm looking for this formula to automatically calculate
our runrate for the month. If I did it manually it would
look like this. Since the days of the month and days left
changes everyday. I'm wondering if this can be possible.

Example- 20(31) / (8) = 77.5 runrate

Hi,



To get the number of days left in a month use this function, if C4 as a
date:



=DATE(YEAR(C4),MONTH(C4)+1,1)-C4-1



The date function here gives the first day of the next month,

Less the date in C4 and less 1 day.




--
JP




"Jason" wrote in message
...
I'm looking for a formula in excel for:

#(days in month) / (days left in month)

I'm looking for this formula to automatically calculate
our runrate for the month. If I did it manually it would
look like this. Since the days of the month and days left
changes everyday. I'm wondering if this can be possible.

Example- 20(31) / (8) = 77.5 runrate

days left
=EOMONTH(TODAY(),0)-TODAY()

"Jason" wrote in message
...
I'm looking for a formula in excel for:

#(days in month) / (days left in month)

I'm looking for this formula to automatically calculate
our runrate for the month. If I did it manually it would
look like this. Since the days of the month and days left
changes everyday. I'm wondering if this can be possible.

Example- 20(31) / (8) = 77.5 runrate