LinkBack URL
About LinkBacks
michaljireht 
try thi formula
and here it is in a spreadsheet
=DATE($C$1,MONTH(DATEVALUE($C$2&"1")),($C$3-1)*7+9-WEEKDAY(DATE($C$1,MONTH(DATEVALUE($C$2&"1")),1)))
weeknumber.xlsx
try thi formula
and here it is in a spreadsheet=DATE($C$1,MONTH(DATEVALUE($C$2&"1")),($C$3-1)*7+9-WEEKDAY(DATE($C$1,MONTH(DATEVALUE($C$2&"1")),1)))
weeknumber.xlsx
Happy with my advice? Click on the * reputation button below
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks