Thread: excel
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Simon Lloyd[_155_] Simon Lloyd[_155_] is offline
external usenet poster
 
Posts: 1
Default 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