Formula Help Combing two AND statements

[Yogi_Bear_79]

I found the following formula on mvps.org

AND($B1>(TODAY()-WEEKDAY(TODAY())),$B1<=(TODAY()-WEEKDAY(TODAY())+7))

In additon to this I also need to check Cell C1 for data:

$C1=""""

I tried a few variations Excel didn't complain, but I didn't get the
expected results:

=AND($C1="""",
(AND($B1>(TODAY()-WEEKDAY(TODAY())),$B1<=(TODAY()-WEEKDAY(TODAY())+7))))

[Yogi_Bear_79]

Disregard i thought of something and it worked right after I posted

"Yogi_Bear_79" <[email protected]> wrote in message
news:[email protected]...
> I found the following formula on mvps.org
>
> AND($B1>(TODAY()-WEEKDAY(TODAY())),$B1<=(TODAY()-WEEKDAY(TODAY())+7))
>
> In additon to this I also need to check Cell C1 for data:
>
> $C1=""""
>
> I tried a few variations Excel didn't complain, but I didn't get the
> expected results:
>
> =AND($C1="""",
> (AND($B1>(TODAY()-WEEKDAY(TODAY())),$B1<=(TODAY()-WEEKDAY(TODAY())+7))))
>
>