Find the First Trading Day (Weekday) after January 1 to Calculate Year to Date Returns

Use Excel functions TODAY, DATE, WEEKDAY, and IFS to display the first trading day (weekday) after January 1st. We use this first trading day to display historical stock prices and ultimately calculate year-to-date returns. #excel #investments #stock #stockhistory #date #weekday #ifs