Automate INDEX/MATCH or VLOOKUP the first date of the week each week.
I want the "Week of" column to automatically show the date of the first day in the current week each week starting with Monday as the first day, and if "Week Of" and "Project Name" both match on another sheet where the data is being enter then I want to return the next 4 columns for the rows where the "Week Of" and "Project Name" both match. I have tried so many formulas, i''m sure I am making this more difficult than it is but I am exhausted now. Please help!
Help Article Resources
Check out the Formula Handbook template!