I'm looking to create a report when we select a week ending date in cell C6 and to have cells b14 though E14 populate with data from the month selected. I'm able to create the index function for YTD in column G but am struggling with formula identifying minimum week within the selected month for columns through EIn.
Last edited by a moderator: