IF function trouble

R

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
:confused:
 
S

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
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top