Hi!

There's about a million ways to do this. Here's a couple:

Assume the dates are in the range A1:A31

In your helper column enter:

=A1

Then use a custom format of: dddd. This will display the weekday as
Wednesday but remember now, this is just a number formatted to display as
Wednesday.

OR

=WEEKDAY(A1,2)<6

This will return TRUE for Monday thru Friday and FALSE for Saturday, Sunday

OR

=IF(WEEKDAY(A1,2)<6,"Yes","No")

OR

=CHOOSE(WEEKDAY(A1,2),"Mon","Tue","Wed","Thur","Fr i","Sat","Sun")

Biff

"vect98" wrote in
message ...

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