Start Monday :
=INT((DAY(A2)+(WEEKDAY(DATE(YEAR(A2);MONTH(A2);1);2))-2)/7)+1
Hope it works
Start Monday :
=INT((DAY(A2)+(WEEKDAY(DATE(YEAR(A2);MONTH(A2);1);2))-2)/7)+1
Hope it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks