hi
it the format.
if you enter"dddd", it will say Friday
if you enter "ddd", it will say Fri
if you enter "mmmm", it will July
if yo enter "mmm" , it will say jul
you did specify the full day name and not just the abriviation.
read up on the text function in help.
Regards
FSt1

"jennifer" wrote:

I am not sure what "dddd" means....

"FSt1" wrote:

hi
with the date in A1, in B1 enter =Text(A1,"dddd")

regards
FSt1

"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!