Thread: excel
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Alice Alice is offline
external usenet poster
 
Posts: 31
Default 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