ExcelBanter - excel

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - excel (https://www.excelbanter.com/new-users-excel/225468-excel.html)

Alice

excel

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 .

Simon Lloyd[_153_]

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

Yevonne

excel

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

joeu2004

excel

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

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.

Alice

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

ALICE