View Single Post
  #2  
Old April 22nd, 2009, 11:59 PM posted to microsoft.public.excel.worksheet.functions
PJFry
external usenet poster
 
Posts: 148
Default calculating percentage of year passed (for sales reports)

Can you provide an example?

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"morneauja" wrote:

I've figured out how to calculate the percentage of the month and quarter
passed, but the options for calculating the percentage of the year passed
have not worked. I keep getting either a vary large percentage or an
infinitesimally small percentage. I know that it is possible to calculate
this because I've seen it on some reports, unfortunately reports were pdf'd
so I can't dig around in the spreadsheet to figure out what the formula is.
Thanks, Julie