"PR" schrieb im Newsbeitrag
...
Jean,
that works, I had to change the semicolon for a comma. this has
brought the
days out, but how will I do this for a week period.

Paul


Paul,

I don't understand what you mean exactly.

Could the following be of interest
The Function WEEKDAY(Date; 2) could help to discard all saturdays and
sundays in making the table, so that there would be no personal quoted
for these two days

(please see the online Help for this function for different options )

If instead of the dates, you put the formula = IF WEEKDAY( "the Date";
2) 5; ""; "the Date")
(Also with the German notation especially about the semicolons )

For that, I put a supplementary date series in the row just above that
one we had up to now (F9;AJ 9) serving as ref. and the indicated
Formula in the Range F10 : AJ 10

The Graph changes correspondingly, Saturdays and Sundays don't have
Columns


I hope I was clear enough

regards
j
Jean