Yes, Thank you very much! I did not have the If/Then statement just right...

"smartin" wrote:

jennifer wrote:
Hello,

I am trying to create a formula that will give the result of "friday" if
payday falls on a Saturday or Sunday. I am assuming that I need an If/Then
function, but I am not sure how to do this with dates. For example, If
payday is on 8/1/2009, it will give me the result of "Friday" Thank you very
much for your help!

Is this what you want?

=IF(WEEKDAY(A1,2)=6,"Friday","")

Of course, I do not know when your paydays are.