In A3:
=DATE(A1,1,1)+CHOOSE(WEEKDAY(DATE(A1,1,1)),0,6,5,4,3,2,1)
A4 then copy down:
=A3+7
Format as you like in format cell/custom
In A3:
=DATE(A1,1,1)+CHOOSE(WEEKDAY(DATE(A1,1,1)),0,6,5,4,3,2,1)
A4 then copy down:
=A3+7
Format as you like in format cell/custom
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks