Date question

[jennifer]

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!

 

[FSt1]

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

regards
FSt1

 

[jennifer]

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

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

regards
FSt1

 

[smartin]

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.

 

[FSt1]

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]

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