day and date in cells

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.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
J

JE McGimpsey

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

Oooga

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.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top