If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Automatically advancing dates in cells for each new year?
Yes Simon I would like to keep the day as well. Thanks -- 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 |
#12
|
|||
|
|||
Automatically advancing dates in cells for each new year?
oh dear i am having a bit of trouble understanding this . i have to put in exactly as you have written it not the actual date. If i right click the cell that i put the above into i dont get FORMAT CELLS ETC in there .......i am doing something wrong but i dont know what ..........sorry -- 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 |
#13
|
|||
|
|||
Automatically advancing dates in cells for each new year?
ALICE;284502 Wrote: oh dear i am having a bit of trouble understanding this . i have to put in exactly as you have written it not the actual date. If i right click the cell that i put the above into i dont get FORMAT CELLS ETC in there .......i am doing something wrong but i dont know what ..........sorry Paste this *=DATE(YEAR(TODAY()),7,2)* (then press enter)in your first cell that has the date (change the month and day if need be) then copy across, all the cells you copied across to should now be highlighted, right click in the highlighted section then choose Format Cells (around half way down under Insert Comment in excel 2007) and follow the formatting i gave you, i could give back your workbook done for you, however, you still won't know how its done then and will face similar problems in the future -- 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 |
#14
|
|||
|
|||
Automatically advancing dates in cells for each new year?
Alice, don't forget all your month sheets are the same structure so you can edit the sheets as a whole group to save you doing them one by one! -- 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 |
#15
|
|||
|
|||
Automatically advancing dates in cells for each new year?
Alice, i have changed the formula slightly and made use of cell A1, A1 now houses a number (1 - 12) this is the number of the month, if you don't wish to see that number then right click Format CellsCustom and in the box type ;;; the number will always be there just not visible unless you select the cell. See the attached (your workbook), you need to complete the pattern for each month for the number of days in the month but it's nearly all done for you! +-------------------------------------------------------------------+ |Filename: WEEKLY CATS formula added.xls | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=102| +-------------------------------------------------------------------+ -- 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 |
#16
|
|||
|
|||
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 . |
#17
|
|||
|
|||
Automatically advancing dates in cells for each new year?
I am really really sorry but I am just not understanding this ........when i put the =DATE(YEAR(TODAY()),7,2) into cell 1B and i am not sure how you mean copy along the rest .............I know I am trying the patience of a saint here but if you could just persevere with me a little longer maybe , just maybe I might get the hang of this........emb1 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 |
#18
|
|||
|
|||
Automatically advancing dates in cells for each new year?
Hi Alice, i have made some changes and completed most of the sheets for you, check out post 17 here http://www.thecodecage.com/forumz/284615-post17.html download the attachment which is your workbook with the formulae inserted etc, you need to finish each sheet of to the end of each month (just a few days) that will help you understand what i've done! -- 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 |
#19
|
|||
|
|||
Automatically advancing dates in cells for each new year?
Thankyou so very much Simon for all your help in this matter........really great Alison -- 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 |
|
Thread Tools | |
Display Modes | |
|
|