Day of week referenced in if statement

[Bert]

I need a formula that will look at a date in a cell and
if the date occurs on any weekday(Mon - Fri), to return
the date in the cell, if not return a zero. I am stumped.

Thanks

 

[Peo Sjoblom]

One way

=(WEEKDAY(A1,2)<6)*1

No need for an IF function in this case

Regards,

Peo Sjoblom

 

[AK]

try this:
=if(and(weekday(cell)>=2,weekday(cell)<=6),cell,"")

 

[Biff]

Hi!

Here's one way. Assume the weekdays are counted as Monday
= 1 and Sunday = 7. Date is in cell A7:

=IF(WEEKDAY(A7,2)<=5,A7,0)

Format as DATE.

Biff

 

[bert]

Perfect, thanks

-----Original Message-----
try this:
=if(and(weekday(cell)>=2,weekday(cell)<=6),cell,"")


.

 

[AK]

life is great, learning new things all the time, didn't know about the
various weekday (sets?)

very cool

 

[Biff]

=(WEEKDAY(A1,2)<6)*1

Doesn't return a date! Returns either 1 or 0.

Biff

 

[Biff]

Hi!

There are 3 different options for weekdays. See the
WEEKDAY function help for more info.

Biff

 

[Peo Sjoblom]

Oops! Must have looked at another question at the same time
However, that is easily fixed

=(WEEKDAY(A1,2)<6)*A1

however both your and my formulas return 01/00/00
if formatted as dates when the formula returns zero for weekends, so I'd
suggest a
custom format m/d/yy;;"0"

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)