Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating Month Average Exch Rate from Exchange Rates Calendar!!!
Hello, All, need Yr help in formula creating. We have exchange rate calendar (USD to Ukranian Hryvna) by every banking day in the year. Data organized as following: col A - dates DD/MM/YYYY, col B - appropriate exchange rate, for instanse - 5,05. I need to have in col C average month exchange rate. So do i need to recognize that date belongs to the same month in the same year and then to include appropriate rate to array for calculating an average? that's my idea... Please comment thanx in advance -- StanUkr ------------------------------------------------------------------------ StanUkr's Profile: http://www.excelforum.com/member.php...o&userid=27232 View this thread: http://www.excelforum.com/showthread...hreadid=467452 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating a weighted average using formula | Excel Worksheet Functions | |||
calculating a weighted average uisng formula | Excel Worksheet Functions | |||
How do I get the average price per bid for an individual month? | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating the number of Fridays in a month | Excel Worksheet Functions |