day and date in cells

  • Thread starter Thread starter Oooga
  • Start date Start date
O

Oooga

I need to make a sheet that has the day and date starting in “A4” and
going for 2 weeks (14cells) “N4”.
How do I get the cells to update each day and date on its own ?
At the end of 2 weeks it will start over, reset to the current day and
date.
 
In B4 enter

=A4 + 1

and copy to N4. Format as day and date.

I'm not sure what you're asking about autmatically update each day, but
also reset every two weeks...
 
That worked just fine. Thank you.

But what I’m looking for is a way to update the dates at the end of the
2 weeks.
With a Macro or something along that line.

Lets say that at the end of my 2 week run, “N4” is equal to Tuesday
2/24/04.
On Wednesday “A4” automatically updates to Wednesday 2/25/04 .

Then with the bit of magic JE McGimpsey gave up, the rest of the sheet
will
follow in line. Thank you for that by the way !

I don’t think it would kill me to put in the date in that one cell on my
own,
but still, the challenge is there.
 
Back
Top