I have searched and tried all the weekday/network day etc formulas but
still can't get this to work.

what i have is a column with dates from the begining to end of the
month. and next to it another column with values.

I wnat to make a graph with this, but only want to use the values where
the date falls between Monday and Friday of that week - i dont mind
creating another column for this but i need a fomrula some sort of IF
statement or something to detrermine whether the date is between monday
and friday.


--
vect98
------------------------------------------------------------------------
vect98's Profile: http://www.excelforum.com/member.php...o&userid=26365
View this thread: http://www.excelforum.com/showthread...hreadid=469759