IF A2=week No and B2= Year in C2 Put This To get date
![]()
=DATE(B2,1,1)+7-WEEKDAY(DATE(B2,1,1),3)+(A2-1)*7
IF A2=week No and B2= Year in C2 Put This To get date
![]()
=DATE(B2,1,1)+7-WEEKDAY(DATE(B2,1,1),3)+(A2-1)*7
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks