automatically show date day by day

B

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!
 
M

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
 
J

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