IF function trouble

[raye]

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

 

[Sandy Mann]

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[raye]

It worked! not getting all of this excel stuff,... but trying...