Forum Discussion
Solved
Start and End dates in same cell
Is there a way to display the start and end date of weeks in same cell (example: Jan 3 - Jan 9) Week 1 Week 2 Week 3 Week 4 Week 5 Jan 3 - Jan 9 Jan 10 - Jan 16 Jan 17 - Jan 23 Jan 24...
See the attached sample workbook.
Enter the year in B1.
The weeks are actually the week numbers 1, 2, ..., with the custom number format "Week "0
The formulas in the cells below use these week numbers.
See the attached sample workbook.
Enter the year in B1.
The weeks are actually the week numbers 1, 2, ..., with the custom number format "Week "0
The formulas in the cells below use these week numbers.