Hi,
I am trying to get an Average YTD value based on one chosen date, where the values is listed in a monthly table, and the values is constant for the whole month showing an average rate for each day.
This average rate for each day I am trying to multiply by number of days in the prior months up till the chosen day (for example 24th of August).
Either a mix of INDEX and MATCH, VLOOKUP or SUMIF have worked, and I can't figure it out...
Kind Regards
Ctrl+V
Bookmarks