LinkBack URL
About LinkBacks
If you replace the "hard-coded" year in the formula with YEAR(R2-31) then you won't ever need to change the formula......i.e.
=INT((R2-DATE(YEAR(R2-31),2,1)-WEEKDAY(R2,1))/7)+2
If you replace the "hard-coded" year in the formula with YEAR(R2-31) then you won't ever need to change the formula......i.e.
=INT((R2-DATE(YEAR(R2-31),2,1)-WEEKDAY(R2,1))/7)+2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks