| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel
can someone please tell me how i can change the date at the beginning of each
year and it will change all the way through my work for the rest of the year? months and weeks . |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
alice;282677 Wrote: can someone please tell me how i can change the date at the beginning of each year and it will change all the way through my work for the rest of the year? months and weeks . Well you didn't give much to go on but entering =TODAY() in a cell will provide you with todays date changing for the relevant date each day....is that what you wanted? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=78961 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
Hi Simon, thanks for your reply .......i tried putting =TODAY() and it put
the date just into one cell . its hard to describe what i am wanting but here goes. i have boxes that i write in for each day of the week for the whole year ahead . i wanted to not have to go through each week every year changing the date and day and somebody did do this for me once but didnt tell me how to do it . can you help as i am a beginner at this. thanks alice "Simon Lloyd" wrote: alice;282677 Wrote: can someone please tell me how i can change the date at the beginning of each year and it will change all the way through my work for the rest of the year? months and weeks . Well you didn't give much to go on but entering =TODAY() in a cell will provide you with todays date changing for the relevant date each day....is that what you wanted? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=78961 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automatically advancing dates in cells for each new year?
Hi I am a real novice with Excel but I would really appreciate some help with what I am trying to achieve. I have lots of boxes or cells do you call them in which i write things for each day of the year. They will each be under each day of the week. The thing is someone did set this up for me but for some reason it no longer works......whether its anything to do with the fact that I have a new computor with maybe different microsoft office 2007 I dont know. Anyway I would like to be able to change the dates for each week by just changing the first day and then the rest of the weeks automatically change to the year i am dealing with ..........hope your understanding all this. I dont want to have to go through each day of each week changing the date in the boxes. Please can anyone help me Thanks Alice -- ALICE ------------------------------------------------------------------------ ALICE's Profile: http://www.thecodecage.com/forumz/member.php?userid=201 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79420 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automatically advancing dates in cells for each new year?
ALICE;284366 Wrote: Hi I am a real novice with Excel but I would really appreciate some help with what I am trying to achieve. I have lots of boxes or cells do you call them in which i write things for each day of the year. They will each be under each day of the week. The thing is someone did set this up for me but for some reason it no longer works......whether its anything to do with the fact that I have a new computor with maybe different microsoft office 2007 I dont know. Anyway I would like to be able to change the dates for each week by just changing the first day and then the rest of the weeks automatically change to the year i am dealing with ..........hope your understanding all this. I dont want to have to go through each day of each week changing the date in the boxes. Please can anyone help me Thanks Alice Alice welcome to The Code Cage Why not upload a sample workbook so we can help you directly with that? Attatchments. To upload a workbook, click reply then add your few words, scroll down past the submit button and you will see the Manage Attatchments button, this is where you get to add files for upload, if you have any trouble please use this link or the one at the bottom of the any page. I will merge your post from the Microsoft Newsgroups with this one too! :) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79420 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automatically advancing dates in cells for each new year?
Title changed to better reflect the content :) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79420 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automatically advancing dates in cells for each new year?
hi i have hopefully attatched on the items i am trying to work on. thankyou +-------------------------------------------------------------------+ |Filename: WEEKLY CATS.xls | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=101| +-------------------------------------------------------------------+ -- ALICE ------------------------------------------------------------------------ ALICE's Profile: http://www.thecodecage.com/forumz/member.php?userid=201 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79420 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
=c4+7
(=columnandrow+7) Put your 1st date in and when you get to the 2nd cell =c4+7 and copy and paste special all the way down. "alice" wrote: can someone please tell me how i can change the date at the beginning of each year and it will change all the way through my work for the rest of the year? months and weeks . |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
"alice" wrote:
can someone please tell me how i can change the date at the beginning of each year and it will change all the way through my work for the rest of the year? months and weeks . There a lot of ways to do this, depending on exactly what you want. It would be helpful if you provided specific examples (always!). Suppose you put the initial date in A1, and you want the same day in each month for 12 months in A2:A13. Then put the following into A2 and copy down: =date(year(A1),1+month(A1),day(A1)) Caveat: That might have undersired results if the day is 31, and if the day is 29 or more and you run through Feb. There are ways to handle that appropriately. But it's not worth the trouble explaining them until you clarify what you want. FYI, advancing the date by one week is simpler. Ostensibly, =A1+7. |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
Have you tried EditReplace?
Gord Dibben MS Excel MVP On Wed, 25 Mar 2009 04:59:01 -0700, alice wrote: can someone please tell me how i can change the date at the beginning of each year and it will change all the way through my work for the rest of the year? months and weeks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
