Hi


Thank you for the help so far.

I have 2 columns A contains the date, B is the time and C is the Week Number. I would like to start a week where the time starts at 6am on a Sunday and finish the following Sunday at 6am.


A B C
14/09/2014 23:28:18 37
14/09/2014 23:28:18 37
14/09/2014 23:41:20 37
14/09/2014 23:48:05 37
15/09/2014 00:25:51 38
15/09/2014 00:35:02 38
15/09/2014 01:14:42 38
15/09/2014 02:28:03 38


I've used =WEEKNUM(A2-0.25,1) but unsure how to integrate the formula with column B as well.

Thanks