Calculating Month Average Exch Rate from Exchange Rates Calendar!!!

S

StanUkr

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[b]calculating Month Average For Exch Rates From Data Array 1
FORMULA: calculating an exchange rate 1
Calculate Average for same period last year 3
Interest calculation 14
Query to lookup and multiply by exchange rates 1
Finding average of 3 results 3
Calculate Average Annual Compounding Rate of Increase 4
Revenue Tracking DB - Need to figure out the table structure. 15

Top