Labeling dates based on the work week it falls under

Hey, first post! Happy to be a part of this forum.

I have, what should be, a relatively easy question.

So I have a column of dates, let's say column A, that consist of dates that only fall in the work week (Mon-Fri). In column B, I want to say if the date in column A is either hold (1/1/2001), late (any date before today), week (today and any date in the current work week), week +1 (any date in the following work week), week +2 (any date in 2 work weeks from today), week +3, week +4, and future (any date more than 4 work weeks from today).

For example: Let's say today is 4/23 (Thursday)
Col A - Col B
1/1/2001 - Hold
4/22/2015 - Late
4/23/2015 - Week
4/24/2015 - Week
4/27/2015 - Week +1
5/6/2015 - Week +2
5/15/2015 - Week +3
5/18/2015 - Week +4
5/25/2015 - Future

So far I've only been able to figure out how to label Hold. =IF(A2=DATE(2001,1,1),"Hold",""). Can someone help me out with this?

Thank you!!

Hi there,
look at the attachement and check if it match Your requirements...
Or paste formula in B1 and drag down as needed:

Formula:

Please Login or Register  to view this content.

Week_labeling.xlsx

Hope it helps

Using WEEKNUM is problematic because it doesn't take account of the year....try this formula

=IF(A2="","",IF(A2=DATE(2001,1,1),"On hold",IF(A2<TODAY(),"Late",CHOOSE(MATCH(A2,TODAY()-WEEKDAY(TODAY(),3)+{0,7,14,21,28,35}),"Week","Week+1","Week+2","Week+3","Week+4","Future"))))