How can I do this with a formula and be able to 'fill right' (or copy and paste right) versus manually type.....
I want a cell to include "W/E 06282024" then in the cell to the right of it, I want 7 days later "W/E07052024". I want to be able to to 'fill right' so 7 days is added to the cell to the right to calculate the current cell and I want the text 'W/E" to start the cell.
So across a row would look like:
W/E 06282024..... W/E 07052024.... W/E 07122024.....W/E 07192024.... etc
Date doesnt' need to be in that exact format.
I do want 'W/E' in each cell.
How can I do this?