Formula Help Combing two AND statements

  • Thread starter Thread starter Yogi_Bear_79
  • Start date Start date
Y

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))))
 
Disregard i thought of something and it worked right after I posted
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to get number of days excluding Fridays in a given period 17
Formula to get number of days within a period excluding Fridays 6
Formula for week ending 2
convert spreadsheet formula into VBA formula 1
sum of weeks sales please 8
if statements returning dates 4
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
Combining two formulas 1

Back
Top