excel

  • Thread starter Thread starter alice
  • Start date Start date
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 .
 
=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 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.
 
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
 
Back
Top