Clearing scheduled work hours for weekends.

[Phil B.]

Unfortunately, this function comes back with a 7.5 or FALSE for both Sat and
Sun.

 

[Tom Hutchins]

Shane's formula works if your DAYs are text values or date values formatted
using the TEXT function. If, instead, your DAYs are actual date values
displayed using custom formats, then a formula like this should work:

=IF(OR(WEEKDAY(B1)=1,WEEKDAY(B1)=7),0,7.5)

This assumes that the first day is in cell B1.

Hope this helps,

Hutch

 

[ShaneDevenshire]

Hi,

As correctly stated by a number of responders, the formula will work IF your
cells really contain Sat and Sun as mentioned in the original email.

If the entries are actual dates then here is a really short formula:

=IF(MOD(A1,7)>1,7.5,0)

 

[Teethless mama]

This one even shorter.

=(MOD(A1,7)>1)*7.5

Hi,

As correctly stated by a number of responders, the formula will work IF your
cells really contain Sat and Sun as mentioned in the original email.

If the entries are actual dates then here is a really short formula:

=IF(MOD(A1,7)>1,7.5,0)

 

[Phil B.]

And the winner goes to Teethless mama!
It worked . . . THANKS to all!