View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason[_18_] Jason[_18_] is offline
external usenet poster
 
Posts: 1
Default formula for days in month - days left???

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