Thanks Sam,
with this “Column” formula is was able to put a “lastyeardate” in front of every “currentyeardate”. necessary since during the weekend there is no currency rate and weekend variates between years.
As you can see on the following image for 21.02.2016 there was no date so this formula returns a +1 or +2 date for those specific cases.
Not sure I’m on the right track since lookup doesn’t work in this case.
Best regards
Mark