Try:

=IF(WEEKDAY(A1,1)=6,"Yes","N0")

or just

=A1 and custom format the cell as dddd and it will show the day of the week

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"raye" wrote in message
...

I'm a beginner, so bear with me...

I'm trying to create an IF statement that will say whether or not a
given date since January,1,1900 is a friday. It should answer "yes" or
"no". I've read a lot of the postings and I'm more confused then
ever.. Please give me some big hints and explain.. Thanx, Raye



--
raye
------------------------------------------------------------------------
raye's Profile:
http://www.excelforum.com/member.php...o&userid=26716
View this thread: http://www.excelforum.com/showthread...hreadid=399772