automatically show date day by day

[Bruno]

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!

 

[Gary''s Student]

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

 

[Mike H]

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

 

[JLatham]

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

 

[Gary''s Student]

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

 

[JLatham]

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.