LinkBack URL
About LinkBacks
If you want to exactly replicate WEEKNUM(A1) where A1 contains a date try this formula
=INT((A1-WEEKDAY(A1)-DATE(YEAR(A1),1,1))/7)+2
If you want to exactly replicate WEEKNUM(A1) where A1 contains a date try this formula
=INT((A1-WEEKDAY(A1)-DATE(YEAR(A1),1,1))/7)+2
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks