Posted to microsoft.public.excel.programming

duane[_26_] duane[_26_] is offline

external usenet poster

Posts: 1

Averaging last 8 weeks

another way without having to enter a date in cell a1 is

AVERAGE(OFFSET($C$1,COUNTA($B$1:$B$1000)-1,0,1,1):OFFSET($C$1,COUNTA($B$1:$B$1000)-8,0,1,1))

this assumes there is no data or dates below the last weeks dat

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=26903

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Formula for weeks	Shihachi	Excel Discussion (Misc queries)	5	December 18th 09 11:47 PM
Date 13 Weeks from now	Craig	Excel Worksheet Functions	3	July 15th 06 11:35 PM
after 2 weeks with the Beta	larune	Excel Discussion (Misc queries)	0	June 18th 06 07:32 AM
calculate weeks from a start date ( not yr weeks)	Todd F.	Excel Worksheet Functions	6	November 27th 04 05:53 PM
Years and Weeks	Michael[_20_]	Excel Programming	3	December 10th 03 03:17 PM

All times are GMT +1. The time now is 04:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us