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