Excel and timesheets

[ChevronB19]

I have an excel template I use for timesheets, where I simply drag a date down vertically and get every day of the year.

Is there any way to do this so each row just has either the first or last day of the week? It would be very useful for a specific task.

Over to you excel gurus...

[Mr Pointy]

Type:
Row 1: 14/04/19
Row 2: 21/04/19

Select the two cells & drag fill down to give a list of weekly incrementing dates. In general if you have two cells & drag fill Excel will try & guess the series you want.

[ChevronB19]

Brilliant, thanks!