excel

A

alice

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 .
 
S

Simon Lloyd

alice;282677 said:
can someone please tell me how i can change the date at the beginning o
eac
year and it will change all the way through my work for the rest of th
year
months and weeks
Click to expand...
Well you didn't give much to go on but entering =TODAY() in a cel
will provide you with todays date changing for the relevant date eac
day....is that what you wanted

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
Y

Yevonne

=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.
 
J

JoeU2004

alice said:
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 .
Click to expand...

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.
 
A

alice

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
 
A

ALICE

Hi I am a real novice with Excel but I would really appreciate some hel
with what I am trying to achieve. I have lots of boxes or cells do yo
call them in which i write things for each day of the year. They wil
each be under each day of the week. The thing is someone did set thi
up for me but for some reason it no longer works......whether it
anything to do with the fact that I have a new computor with mayb
different microsoft office 2007 I dont know. Anyway I would like to b
able to change the dates for each week by just changing the first da
and then the rest of the weeks automatically change to the year i a
dealing with ..........hope your understanding all this. I dont want t
have to go through each day of each week changing the date in the boxes
Please can anyone help me
Thanks Alic
 
S

Simon Lloyd

ALICE;284366 said:
Hi I am a real novice with Excel but I would really appreciate some hel
with what I am trying to achieve. I have lots of boxes or cells do yo
call them in which i write things for each day of the year. They wil
each be under each day of the week. The thing is someone did set this u
for me but for some reason it no longer works......whether its anythin
to do with the fact that I have a new computor with maybe differen
microsoft office 2007 I dont know. Anyway I would like to be able t
change the dates for each week by just changing the first day and the
the rest of the weeks automatically change to the year i am dealing wit
..........hope your understanding all this. I dont want to have to g
through each day of each week changing the date in the boxes. Please ca
anyone help m
Thanks Alic
Click to expand...

Alice welcome to The Code Cag

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 dow
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 troubl
please use this link or the one at the bottom of th
any page.
I will merge your post from the Microsoft Newsgroups wit
this one too! :

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
S

Simon Lloyd

If you want to keep the structure use this example in the cel
*=DATE(YEAR(TODAY()),7,2)* and then right click the cell Forma
Cells>Custom double click the word "General" in the box and paste thi
in *mmmm dd yyyy dddd

To explain:*=DATE(YEAR(TODAY()),7,2)
the* DATE *function allows your to specify the components of the date
the *YEAR* function allows you to split a year out from a date, if w
use the TODAY function it will mean the year will always be the curren
year, the rest is self explanatary 7 = july...et

*mmmm dd yyyy dddd
when formatting dates we can tell Excel how much or what depth eac
part of the date should be shwon as so, dd mm yy would display 01 0
2009 (assuming its january 1st) using dd mmm yy would display 01 Ja
09....you get the idea

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
A

ALICE

oh dear i am having a bit of trouble understanding this . i have to pu
in exactly as you have written it not the actual date. If i right clic
the cell that i put the above into i dont get FORMAT CELLS ETC in ther
.......i am doing something wrong but i dont know what ..........sorr
 
S

Simon Lloyd

ALICE;284502 said:
oh dear i am having a bit of trouble understanding this . i have to pu
in exactly as you have written it not the actual date. If i right clic
the cell that i put the above into i dont get FORMAT CELLS ETC in ther
.......i am doing something wrong but i dont know what ..........sorr
Click to expand...
Paste this *=DATE(YEAR(TODAY()),7,2)* (then press enter)in your firs
cell that has the date (change the month and day if need be) then cop
across, all the cells you copied across to should now be highlighted
right click in the highlighted section then choose Format Cells (aroun
half way down under Insert Comment in excel 2007) and follow th
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 simila
problems in the future :

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
S

Simon Lloyd

Alice, don't forget all your month sheets are the same structure so yo
can edit the sheets as a whole group to save you doing them one by one

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
S

Simon Lloyd

Alice, i have changed the formula slightly and made use of cell A1, A
now houses a number (1 - 12) this is the number of the month, if yo
don't wish to see that number then right click Format Cells>Custom an
in the box type ;;; the number will always be there just not visibl
unless you select the cell

See the attached (your workbook), you need to complete the pattern fo
each month for the number of days in the month but it's nearly all don
for you

+-------------------------------------------------------------------
|Filename: WEEKLY CATS formula added.xls
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=102
+-------------------------------------------------------------------

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
A

ALICE

I am really really sorry but I am just not understanding thi
........when i put the =DATE(YEAR(TODAY()),7,2) into cell 1B and i a
not sure how you mean copy along the rest .............I know I a
trying the patience of a saint here but if you could just persever
with me a little longer maybe , just maybe I might get the hang o
this........emb1:confused:

thanks,
Alic
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word OLE to check spelling in text box 1
OLE Word spelling 0
Send meeting request for different dates (no repetition) to different people 0
Why am I getting this error? 0
Excel opening 1
New computer, how do i move outlook 365 ENTIRELY? 0
Resource name inside resource sheet: per person, work per hours per week 0
Images are pixelated when saving to PDF 0

Top