nested if statements

[suzyt1374]

I am trying to write a formula that will look at a date in column H2 and determine if that date is a prior week, week 1 or week 2

For example anything older than or equal to 8/19/17 is prior, any date between 8/20-8/26 is week 1, and any date between 8/27-9/2 is week 2.

I have it already done to isolate week 1 or week 2 but need to capture prior week. This is what I have to build off of, any help would be appreciated.

=IF(H2<=DATEVALUE("08/26/17"),"week 1","week 2")

there will be all different dates in column h2 ranging back a over a month or more in some cases.

 

[C with no eyes]

IF(H2<today()-6-weekday(today(),1),"prior week",
<

TODAY()-6-WEEKDAY(TODAY(),1),"Prior week",
<today()-6-weekday(today(),1),"prior week",

IF(AND(H2>=TODAY()-6-WEEKDAY(TODAY(),1),H2<=TODAY()-WEEKDAY(TODAY(),1)),"Week 1",

IF(AND(H2>=TODAY()+1-WEEKDAY(TODAY(),1),H2<=TODAY()+7-WEEKDAY(TODAY(),1)),"Week 2")))</today()-6-weekday(today(),1),"prior></today()-6-weekday(today(),1),"prior>

 

[Joe4]

Looks like you are still having issues.
Be sure to place the spaces both BEFORE and AFTER your < and > signs.

 

[C with no eyes]

Nope, it works if you copy and paste it. Just needs an = adding at the beginning.