Date question

J

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

smartin

jennifer said:
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!
Click to expand...

Is this what you want?

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

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

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
 
Top