Date question

  • Thread starter Thread starter jennifer
  • Start date Start date
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!
 
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
 
Back
Top