hans2103’s avatarhans2103’s Twitter Archive—№ 2,853

  1. Google Docs weeknumber (H2=monday) =INT((H2-DATE(YEAR(H2-WEEKDAY(H2-1)+4);1;3)+WEEKDAY(DATE(YEAR(H2-WEEKDAY(H2-1)+4);1;3))+5)/7)