Excel Day Increment question

[AHarvey]

Hi all,

I have two rows, one with the Day in and one with the Date in.

I want to be able to insert a Day and Date into the rows and then for it to automatically fill in the cells to the right of it.

The Date was simple with a quick =B2+1 however I can't figure out who to do this with the Day.

I know you can just select the Day cell and drag it right and it automatically increments them, however, I want to speed it up slightly and just enter the day once.

Any help gratefully received!

 

[Clairvoyant]

If you type Monday then Tuesday in the next cell then select the 2 cells then drag and fill the same as normal. That should then fill in the days of the week.

 

[londonbairn]

Another way (better if the dates change) is to put the following formula

=TEXT(WEEKDAY(B2), "dddd")

where B2 is the date above and drag that across.

If you change the date above it, it will update below without having to remanually edit.

 

[AHarvey]

Another way (better if the dates change) is to put the following formula

=TEXT(WEEKDAY(B2), "dddd")

where B2 is the date above and drag that across.

If you change the date above it, it will update below without having to remanually edit.

Worked a treat, thank you!