LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default How to Calculate the average Daily price within a time period


I need to calculate the average Daily price of a particular product within a specified time period i.e. between two dates, Sep 16 2014 & Feb 15 2015

The daily price of the product, during the above-mentioned time period, has revised as per the table below

Aug 31 2014 : $74.58
Oct 01 2014 : $75.46
Oct 15 2014 : $74.29
NOv 01 2014 : $71.68
Dec 01 2014 : $70.73
Dec 16 2014 : $68.65
Jan 12 2015 : $68.66
Jan 17 2015 : $66.64
Feb 04 2015 : $64.60


Thanks for the help

San
 
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
How to average values based on time period Peters48 Excel Worksheet Functions 6 January 9th 10 06:36 PM
Calculate Average for same period last year irish_hp Excel Discussion (Misc queries) 3 April 16th 08 11:22 AM
average rate of change per given time period between 2 moments in time of a value David Virgil Hobbs Excel Worksheet Functions 1 December 19th 06 07:24 AM
average rate of change per given time period between 2 moments in time of a value David Virgil Hobbs Excel Programming 1 December 19th 06 07:24 AM
calculate/convert volume price to monthly average price Bultgren Excel Worksheet Functions 2 February 14th 06 09:36 AM


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