You can do exactly the same, but the other way around!
In B1 put
=WORKDAY(A1,1)
and fill it across!
Andy.
"lsmft" wrote in
message ...
Thanks for the fast response Andy, but this is not working for me.
I mistated my question though. I should have stated that I click on
cell A-1 and drag across on Row 1 until I get to June 30. In this way
each day will have it's own column.
Sorry for my confusing question.
Let's say:
A-1 is Jan 1, 2006
B-1 is Jan 2, 2006
C-1 is Jan 3, 2006 etc.
--
lsmft
------------------------------------------------------------------------
lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=520746