Work Week and Weekdays starts at different time

[munra6]

Hello,
I have been looking through different posts but I am still not able to find quite the solution.
Basically my problem is that I need to obtain the week number of the year and the number of day of the week from a column that I have with dates in the following format: 1/29/2018 7:08:17 AM. This may sound easy with the WEEKDAY and WEEKNUM functions but the twist here is that my work days starts at 7:00:00 AM. My week starts in Monday at 7:00:00AM and finish next Monday at 6:59:59 AM.

Example:
Since 01/01/2018 8:00:00 AM was a Monday, this date for me is Week 1, Day 1 (WW1.1).
01/02/2018 9:00:00 AM was a Tuesday so this date would be Week 1, Day 2 (WW1.2)
But the date 01/02/2018 3:40:00 AM is still considered Week 1, Day 1 because it is before 7:00:00 AM.

I would appreciate any help or recommendation on this topic. Also let me know any other clarification needed.

Best regards.

 

[Tetra201]

Is this what you need?

="WW"&WEEKNUM(A1-"7:00",2)&"."&WEEKDAY(A1-"7:00",2)

 

[munra6]

Is this what you need?

="WW"&WEEKNUM(A1-"7:00",2)&"."&WEEKDAY(A1-"7:00",2)

That is exactly what I needed it. Thank you very much sir!
I was already expecting to nest 64 IF.
Thanks again.

 

[Tetra201]

Glad to have helped.