automatically show date day by day

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruno - 15 Mar 2008 11:45 GMT

I need to make a list with all the days of the year in it. It is very
cumbersome to enter every day manually. Is there a way to do it
automatically? Thank you!

Reply to this Message

Gary''s Student - 15 Mar 2008 12:01 GMT

In A1 enter:
1/1/2008
In A2 enter:
=A1+1 and copy down

Signature

Gary''s Student - gsnu200773

Reply to this Message

JLatham - 15 Mar 2008 14:48 GMT

Guess Bruno forgot to mention he was only interested in workdays? grrrr...?

> In A1 enter:
> 1/1/2008
> In A2 enter:
> =A1+1 and copy down

Reply to this Message

Gary''s Student - 15 Mar 2008 15:40 GMT

"a list with all the days of the year in it"

Signature

Gary''s Student - gsnu200773

> Guess Bruno forgot to mention he was only interested in workdays? grrrr...?
>
> > In A1 enter:
> > 1/1/2008
> > In A2 enter:
> > =A1+1 and copy down

Reply to this Message

JLatham - 15 Mar 2008 16:32 GMT

That's pretty much what I read also, and would have provided much the same
answer. We can't hit 'm all dead center every time.

> "a list with all the days of the year in it"
>
[quoted text clipped - 4 lines]
> > > In A2 enter:
> > > =A1+1 and copy down

Reply to this Message

Mike H - 15 Mar 2008 12:58 GMT

Or for workdays only try this with a start date in A1

=WORKDAY(A1,1)

and if you look in help you'll find how to exclude holidays too

Mike

> I need to make a list with all the days of the year in it. It is very
> cumbersome to enter every day manually. Is there a way to do it
> automatically? Thank you!

Reply to this Message