Yes it is but you would need to set it up which is not automatic.
It could be done either by using a worksheet event macro that would
excute when the user has pressed the enter key after typing in the date
or by using an IF formula with some testing for weekdays copied accross.
Since it's not a 10 second solution I'd suggest you do a google seach fro
excel even macros

Tera,

If I understand the question properly, you want the user to supply a start
date and end date, and have the worksheet provide weekdays across the sheet.
How far it goes across the sheet depends on the end date.  Peo has touched
on this.  If there will be nothing on the sheet beyond the end date column,
then formulas could be used.  But if there will be other stuff beyond the
last date column (Row totals, other data, etc.), then it's different, and I
think a macro will have to insert columns, provide the dates, etc.  A
somewhat specialized solution.    Supply info.