I have weekdays listed in column A from row 6 to 371 (this is fixed). Based on that range, how can I display on another sheet each week in column A? I'd like to avoid Week1, Week2, etc. I'd rather have the start date in one cell and the end date in another cell for each week (business days).
What would be the formula (VBA not an option)?