LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gevans
 
Posts: n/a
Default rolling 12 month average

I need formula that will determine a rolling 12 month average. I'm starting
with individual days, so I need something that will recognise the start and
end of each month, something that is date based rather than just count based.
Any ideas?
Thanks in advance!
--
gevans
 
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
Rolling up to the correct Month Dilemma salooha Excel Discussion (Misc queries) 0 February 9th 06 09:18 PM
Formula for calculating a rolling 12 month average in excel? Jeff Excel Discussion (Misc queries) 1 December 9th 05 09:11 PM
Rolling 3 mth Average dallin Excel Worksheet Functions 1 November 22nd 05 04:10 PM
Average starting with first month Jim Excel Discussion (Misc queries) 7 October 29th 05 12:48 PM
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! StanUkr Excel Worksheet Functions 0 September 14th 05 11:12 AM


All times are GMT +1. The time now is 03:52 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"