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