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

[BigBadTex]

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

 

[Paul Sheppard]

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

(e-mail address removed)

 

[vezerid]

I wish to add the days of the week to a spreadsheet and skip every othe
column. This can easily be done by manually entering it; however, a
the date changes with it's corresponding day from month to month ther
is a need to change these every 2 weeks. For example, lets say tha
the 1st of last month, October, fell on a Saturday. This month i
falls on a Tuesday. I wish to be able to open the spreadsheet, go t
the cell containing the day of the 1st (i.e. Sat) and change it to th
new day (Tue) with it resulting in all preceeding days changin
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 tha
you may take a look at it. The problem is quite obvious upo
examiniation.

Jonathan

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

HTH
Kostis Vezeride