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
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk


"raye" <raye.1ug3uc_1125183920.9481@excelforum-nospam.com> wrote in message
news:raye.1ug3uc_1125183920.9481@excelforum-nospam.com...
>
> 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
>