Excel Question

[marine1]

I want to have days of the week go from Monday to Sunday and so on.
I thought you would be able to do this for example
A1 is Monday
A2 should say Tuesday
A3 Wed

Etc

I tried =A2+1
A3+1 etc but this did not work.

What am I doing wrong?

 

[yebocan]

I want to have days of the week go from Monday to Sunday and so on.
I thought you would be able to do this for example
A1 is Monday
A2 should say Tuesday
A3 Wed

Etc

I tried =A2+1
A3+1 etc but this did not work.

What am I doing wrong?

Type Monday in A1 and than just drag down, not in high heels...Excel will populate A2, A3, etc with the days in sequence.

 

[Skywalker42]

=TEXT(1,"dddd") Sunday
=TEXT(2,"dddd") Monday

or

=TEXT(WEEKDAY(INDIRECT("A1")),"dddd")

or

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

or

=CHOOSE(WEEKDAY("31 July 2007"),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday") ")

More here:

http://www.ozgrid.com/Excel/weekday-date.htm

http://www.techonthenet.com/excel/formulas/weekday.php

 

[marine1]

Type Monday in A1 and than just drag down, not in high heels...Excel will populate A2, A3, etc with the days in sequence.

Err does not work

=TEXT(1,"dddd") Sunday
=TEXT(2,"dddd") Monday

or

=TEXT(WEEKDAY(INDIRECT("A1")),"dddd")

or

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

or

=CHOOSE(WEEKDAY("31 July 2007"),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday") ")

More here:

http://www.ozgrid.com/Excel/weekday-date.htm

http://www.techonthenet.com/excel/formulas/weekday.php

Thanks

 

[Richardxtc]

I want to have days of the week go from Monday to Sunday and so on.
I thought you would be able to do this for example
A1 is Monday
A2 should say Tuesday
A3 Wed

Etc

I tried =A2+1
A3+1 etc but this did not work.

What am I doing wrong?

Type monday into A1 then press enter, highlight A1 again and at the bottom right corner of the hilighted cell will be a little square, drag that down 6 more cells. If it just copies mondays in the lower cells then just before u deselect the higlighted cells a little box will pop up at the bottom right click that and then choose continue series.

 

[marine1]

Type monday into A1 then press enter, highlight A1 again and at the bottom right corner of the hilighted cell will be a little square, drag that down 6 more cells. If it just copies mondays in the lower cells then just before u deselect the higlighted cells a little box will pop up at the bottom right click that and then choose continue series.

Thank you thank you thank you.
Easy simple when you know how. Thumbs up to you.

 

[charlh]

I want to have days of the week go from Monday to Sunday and so on.
I thought you would be able to do this for example
A1 is Monday
A2 should say Tuesday
A3 Wed

Etc

I tried =A2+1
A3+1 etc but this did not work.

What am I doing wrong?

Format the column as date, using the custom option with 'dddd'. Just type '2' in the first cell, and it will be Monday (1=Sunday, 2=Monday etc). You can then use your formulas as in the OP. Hope it helps