formula for days in month - days left???

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

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 >
 
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.
 
Back
Top