Adding Days (i.e. Mon, Tue, Wed, Thur...) to sheet
 

I wish to add the days of the week to a spreadsheet and skip every other
column. This can easily be done by manually entering it; however, as
the date changes with it's corresponding day from month to month there
is a need to change these every 2 weeks. For example, lets say that
the 1st of last month, October, fell on a Saturday. This month it
falls on a Tuesday. I wish to be able to open the spreadsheet, go to
the cell containing the day of the 1st (i.e. Sat) and change it to the
new day (Tue) with it resulting in all preceeding days changing
accordingly. Is this possible? How would one go about doing so?
Thanks for your time and effort in advance.

If this isn't clear I would be glad to send you the spreadsheet so that
you may take a look at it. The problem is quite obvious upon
examiniation.

Jonathan


--
BigBadTex
------------------------------------------------------------------------
BigBadTex's Profile: http://www.excelforum.com/member.php...o&userid=28476
View this thread: http://www.excelforum.com/showthread...hreadid=480857

Adding Days (i.e. Mon, Tue, Wed, Thur...) to sheet
 

BigBadTex Wrote:
I wish to add the days of the week to a spreadsheet and skip every other
column. This can easily be done by manually entering it; however, as
the date changes with it's corresponding day from month to month there
is a need to change these every 2 weeks. For example, lets say that
the 1st of last month, October, fell on a Saturday. This month it
falls on a Tuesday. I wish to be able to open the spreadsheet, go to
the cell containing the day of the 1st (i.e. Sat) and change it to the
new day (Tue) with it resulting in all preceeding days changing
accordingly. Is this possible? How would one go about doing so?
Thanks for your time and effort in advance.

If this isn't clear I would be glad to send you the spreadsheet so that
you may take a look at it. The problem is quite obvious upon
examiniation.

Jonathan

Hi Jonathan

Have a look at the WEEKDAY function, this should give you what you
want

If you still need help send me the file and I'll have a look at it for
you




--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=480857

Adding Days (i.e. Mon, Tue, Wed, Thur...) to sheet
 

BigBadTex Wrote:
I wish to add the days of the week to a spreadsheet and skip every other
column. This can easily be done by manually entering it; however, as
the date changes with it's corresponding day from month to month there
is a need to change these every 2 weeks. For example, lets say that
the 1st of last month, October, fell on a Saturday. This month it
falls on a Tuesday. I wish to be able to open the spreadsheet, go to
the cell containing the day of the 1st (i.e. Sat) and change it to the
new day (Tue) with it resulting in all preceeding days changing
accordingly. Is this possible? How would one go about doing so?
Thanks for your time and effort in advance.

If this isn't clear I would be glad to send you the spreadsheet so that
you may take a look at it. The problem is quite obvious upon
examiniation.

Jonathan

Jonathan,
it seems to me that the function you need is =TEXT(A2, "dddd")

HTH
Kostis Vezerides


--
vezerid
------------------------------------------------------------------------
vezerid's Profile: http://www.excelforum.com/member.php...o&userid=28481
View this thread: http://www.excelforum.com/showthread...hreadid=480857