Date question
 

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!

Date question
 

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!

Date question
 

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!

Date question
 

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.

Date question
 

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!

Date question
 

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.