Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get a row consecutive from a sheet to another | Excel Worksheet Functions | |||
Sum total formula for adding 2 columnson time sheet | Excel Worksheet Functions | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
balance sheet template in excel adding lines | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |