Does this mean a new printed page on that single worksheet?

Or does it mean you want a different worksheet for each of those dates? If you
mean this, where does the date go--is it the name of the worksheet or is it a
cell in the worksheet?



msiz wrote:

thanks
sorry should have been clearer - I will need a new page for every day of the
week
msiz

"Dave Peterson" wrote:

Put
01/01/2007
in the top cell (A1)
Format|Cells|Number tab|Custom category
dddd d mmmm yyyy

And select that cell
rightclick on the autofill button (the little square in the bottom right corner
of the selected cell)
and drag down as far as you want.

When you release the mouse, you can choose from a bunch of
possibilities--including "Fill Weekdays"



msiz wrote:

hi
I am making a new room booking form and I want it to show the day and date
ie. "Monday 1 January 2007". How do I make a formula that will include the
day as well as the date, and omit weekends?
Thanks
msiz

--

Dave Peterson


--

Dave Peterson