Assign a value based on a date range

kolfinna

Hi everyone,

Fairly newish user when it comes to formulas here; please forgive me if this has been answered elsewhere and I missed it in my searching.

I'm wanting to assign a value to a column named Bucket based on the value in the Start column for any given task. The date ranges look like this (using a numbered list for the bucket value, because why not):

1. 2/20/20 - 2/26/20
2. 2/27/20 -  3/4/20
3. 3/5/20 - 3/11/20
4. 3/12/20 - 3/18/20

...and so on. This particular portion of the project should take no more than 10-12 weeks to complete.

Is there an easier way to do this than nested IF statements? So far I've been thinking down the track of

=IF([Start]@row&gt;2/19/20<2/27/20,"1",IF([Start]@row ...) etc. In pseudocode. 

Thoughts?

Thanks!

Thiago Castro

Hi Kolfinna

Can you please try this:

=IF(AND([Start]@row&gt;=2/20/20,End]@row&lt;=2/26/20),1,IF(AND([Start]@row&gt;=2/27/20,[End]@row&lt;=3/4/20),2,""))

 (I typed the date for the sake of example, but it's recommended to link to the correct cell)

I hope it helps.