A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do I make different length months the same value?



 
 
Thread Tools Display Modes
  #1  
Old February 10th, 2005, 02:43 AM
bee333
external usenet poster
 
Posts: n/a
Default how do I make different length months the same value?

If I am doing a monthly report with daily figures, some months will be worth
more based on the days. How do I give the twelve months a relative value so
that February is worth the same as any other 31 day month?
  #2  
Old February 10th, 2005, 03:21 AM
R.VENKATARAMAN
external usenet poster
 
Posts: n/a
Default

this is statistsical llproblem. why not have one days rate. jan values will
be divided by 31 and february will be divided by 28(or 29). how about that.


bee333 wrote in message
...
If I am doing a monthly report with daily figures, some months will be

worth
more based on the days. How do I give the twelve months a relative value

so
that February is worth the same as any other 31 day month?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Limit on Scenario name length kraester General Discussion 2 August 10th, 2004 09:41 AM
How do you make a fixed length (85 characters) format report out . carter General Discussion 6 August 7th, 2004 12:45 AM
MAKE QUICK CASH RIGHT NOW!!! 100% LEGAL, INSTRUCTIONS IN THIS POST!! MAKE CASH NOW!!! Setting up and Configuration 0 December 12th, 2003 06:36 PM


All times are GMT +1. The time now is 07:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.