How to convert monthly exchange rates into daily time scale

Dear colleagues,

 

I have daily cash flows forecast in foreign currency (for treasury purposes) and monthly exchange rates forecast. An only I need for daily cash flows forecast in local currency is: convert monthly exchange rates into daily time scale, but it looks to be sophisticated formula. Thank you in advance for any ideas!

--

Module1: Exchange rates (only Time dimention and single line item)

Time Scale  Exchange Rate

Jan18          60.0000 

Feb18          65.0000 

 

Module2: CF Forecast (only Time dimention and single line item)

Time Scale    Exchange Rate

01 Jan 18      60.0000 to be displayed here

02 Jan 18

03 Jan 18  

Tagged:

Best Answer

  • Hi, 

     

    Use the MONTHVALUE function.

     

    In the Day formatted module, the formula might be MONTHVALUE(Exchange Rates.Rate)

     

    Cheers!

     

    Paul