I'm thinking that I'm asking the question in the wrong way, and also am bad at making example workbooks so i'm attaching along a copy of the original.
What I'm trying to do is populate Planner D18 through D40 named "Prioritized Task List" with a list from SMITDAILY contingent on the day. So if today is Sunday I want the vertical list from SMITDAILY A3 through A23 to populate in Planner D18 through D38, however if today is Thursday, I want the vertical list from SMITDAILY E3 through E24 to populate in Planner D18 through D39. I have gotten the to populate with the given formula, however, I have to manually change the day. I would like those cells to recognize which day of the week it is and input the correct text from SMITDAILY to Planner.
Last edited by Cero197; 05-02-2019 at 11:09 PM.
Reason: Forgot to add attachment
|