LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Days per month for calculating storage days Bart Excel Worksheet Functions 3 January 31st 07 06:40 PM
Working days left in a month. [email protected] Excel Worksheet Functions 4 January 28th 07 09:56 PM
I'm looking for a formula to calc # of days left in a month Manthony Excel Worksheet Functions 3 June 6th 06 03:15 PM
Number of days left in the Month? elfmajesty Excel Discussion (Misc queries) 10 March 21st 06 11:09 PM
Working days left in the month compared to previous months qwopzxnm Excel Worksheet Functions 8 October 24th 05 08:00 PM


All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"