Week days calculation function

Hi Experts,

Random task given to me label data details in weeks. Week could start randomly in a week and go sequentially to next week 2 week 3 week 4and so on as per requirement.
Please see below .

Challenge I faced is calculating 7 day in a week , as raw data date runs in over 100s of rows
Any guidance given or suggestion for function that will populate without manual intervention is welcomed

Thanks in advance
Karnik


22-Nov-16
22-Nov-16
22-Nov-16
23-Nov-16 Wed Week 1
23-Nov-16 Wed Week 1
23-Nov-16 Wed Week 1
23-Nov-16 Wed Week 1
23-Nov-16 Wed Week 1
24-Nov-16 Thu Week 1
25-Nov-16 Fri Week 1
25-Nov-16 Fri Week 1
25-Nov-16 Fri Week 1
25-Nov-16 Fri Week 1
25-Nov-16 Fri Week 1
25-Nov-16 Fri Week 1
25-Nov-16 Fri Week 1
27-Nov-16 Sun Week 1
27-Nov-16 Sun Week 1
28-Nov-16 Mon Week 1
28-Nov-16 Mon Week 1
28-Nov-16 Mon Week 1
28-Nov-16 Mon Week 1
29-Nov-16 Tue Week 1
29-Nov-16 Tue Week 1
29-Nov-16 Tue Week 1
29-Nov-16 Tue Week 1
29-Nov-16 Tue Week 1
29-Nov-16 Tue Week 1
29-Nov-16 Tue Week 1
30-Nov-16 Wed Week2
30-Nov-16 Wed Week2
30-Nov-16 Wed Week2
1-Dec-16 Thu Week2
1-Dec-16 Thu Week2
1-Dec-16 Thu Week2
1-Dec-16 Thu Week2
1-Dec-16 Thu Week2
1-Dec-16 Thu Week2
1-Dec-16 Thu Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
2-Dec-16 Fri Week2
3-Dec-16 Sat Week2
3-Dec-16 Sat Week2
3-Dec-16 Sat Week2
3-Dec-16 Sat Week2
3-Dec-16 Sat Week2
3-Dec-16 Sat Week2
3-Dec-16 Sat Week2
3-Dec-16 Sat Week2
3-Dec-16 Sat Week2
3-Dec-16 Sat Week2
4-Dec-16 Sun Week2
5-Dec-16 Mon Week2
5-Dec-16 Mon Week2
5-Dec-16 Mon Week2
5-Dec-16 Mon Week2
5-Dec-16 Mon Week2
5-Dec-16 Mon Week2
7-Dec-16
7-Dec-16
7-Dec-16
7-Dec-16

Hi
assuming your start date is in cell A4, try this formula

="Week "&1+ROUNDDOWN((A4-$A$4)/7,0)

Hi,

Here is a formula you can use to return your week numbers :

Please Login or Register  to view this content.

The first part determines the number of the week in the year. The second part subtracts a week number of a baseline date minus 1.

Attached is an example using the data you provided.

Hope this makes sense and is helpful.

Cheers

Hi Nicyc & Southward,

Thanks for the brilliant suggestion, both works and amazed to see the contrast functions
Cheers
Karnik

You are very welcome. Glad I could be of some assistance.

Cheers