Pick Closest Date from a row of dates|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I am new to IF or AND statements.

I have a date range of Mondays for each week of the year (7/1/2019, 7/8/2019, 7/15/2019, for the 52 weeks of a year) in row 1 (Green), starting with F1

I have a date in C2 (Blue) (Example:9/8/2019) I want to have Cell D2 (Yellow) find and show the closest date >or = to a date in row 1,

In this case it would display 9/9/2019 in D2 (Yellow)