adding days of the week

[swervingcheetah]

Is it possible to do a formula like Friday+1 in a cell to generate saturday? I have a cell displaying Friday and want to drag and auto fill the days of the week for the month. B4 = FRI, and i want B5 to equal Saturday, B6 to equal sunday etc. Is there a simple way for this?

[Ron Coderre]

Is it possible to do a formula like Friday+1 in a cell to generate saturday? I have a cell displaying Friday and want to drag and auto fill the days of the week for the month. B4 = FRI, and i want B5 to equal Saturday, B6 to equal sunday etc. Is there a simple way for this?

Yes...
B4: a "Friday" date....2012-05-18
B5: =B4+1
Copy that formula down as far as you need.

Alternatively, you could Click and Hold on the B4 fill handle (little black box in the lower right corner) and drag down to create a date series.

Does that help?

[jeffreybrown]

If you place your cursor on the cell with Friday, pull down on the fill handle and Excel will auto fill the days of the week

[swervingcheetah]

Yes, I want to just have to change friday going forward, and the rest will auto change. I guess i could have been more clear. and B4+1 doesn't work

[Ron Coderre]

Yes, I want to just have to change friday going forward, and the rest will auto change. I guess i could have been more clear. and B4+1 doesn't work

I think you'll need to clarify what "doesn't work" means.
The assumption I made was that cell B4 contained an actual date.
The B5 formula will return the next Excel date serial number after that date.
(You'll need to format the formula cells to display a format that's appropriate)

If that doesn't help...can you post a sample workbook the demonstrates the problem?

[daddylonglegs]

If B4 contains the full weekday name like "Friday" you can use this formula in B5 copied down to populate subsequent weekdays

=INDEX(TEXT({1,2,3,4,5,6,7,8},"dddd"),MATCH(B4,TEXT({1,2,3,4,5,6,7},"dddd"),0)+1)

[Ron Coderre]

One other thought...
Excel already contains built-in lists for days of the week.
If you enter Friday in B4
then drag the fill handle down you'll see the subsequent days: Saturday, Sunday...etc

Is that a feature you can use?

[Haseeb Avarakkan]

Or,

In B5, then copy down.

=TEXT(MATCH(2,SEARCH(B4,TEXT({1,2,3,4,5,6,7},"dddd")))+1,"dddd")

Should work (unless any one found any mistakes ), If B4 contains weeks with short or full day, ie Sunday, Sun, Su etc...