Posted to microsoft.public.excel.misc

Ross

external usenet poster

Posts: 152

Average between two dates

Hi,

I have a data range consisting of:
Date Daily total Cumm Total Target
1/1/06 189 189 157
2/1/06 73 262 314

and I want to have reference cells where I can change the dates and have a
formula in a seperate cell that looks to the data range and retruns an
average value from daily total between these two dates

Thanks,
Ross

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Figuring daily average...function ???	Fish	Excel Worksheet Functions	7	March 10th 06 05:26 PM
AVERAGE DAYS OPEN IF BETWEEN DATES	kathi	Excel Worksheet Functions	4	February 28th 06 03:45 PM
What is this kind of average called?	havocdragon	Excel Worksheet Functions	3	June 24th 05 05:10 PM
Calculate Years/Months Between Dates and then Average	Missy	Excel Discussion (Misc queries)	3	February 12th 05 04:19 AM
Formating Dates for production schedule	dpl7579	Excel Discussion (Misc queries)	1	January 11th 05 08:43 PM

All times are GMT +1. The time now is 03:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us