Use the DATE and WEEKDAY functions as shown in the following formula:
=DATE(C2,1,3)-WEEKDAY(DATE(C2,1,3),1)+7*(B2-1)+A2
Related posts:
K M Mahmud Hasan’s Website
www.mahmudhasan.com
Some thoughts....
graphicarts This page contains my Notes and slides for the classes, I am and will taking in Graphic Arts Institute . Just right click and then click save as and save into your drive. PowerPoint PowerPoint...
7 Functions of Human Resource Management This is broadly defined as any part of the management structure relating to people at work. It involves everything from recruitment to training to performance appraisal and overall employee welfare. HRM...
Special Topics in Training and Development Orientation A formal process of familiarizing new employees with the organization, their jobs, and their work units. Benefits: 1.Lower turnover 2.Increased productivity 3.Improved employee...
Foreign Bribery -- bribery condemned and illegal in many countries, yet practiced widely -- is it ethical to give into demands of bribery? ("when in Rome, do asthe Romans do?") ∙ What is bribery?...
Briefly explain the two types of informal communication... Three main characteristics of a grapevine: First, it is not controlled by management. Second, it is perceived by most employees as being more believable and reliable than formal communiqués....
I found a fault in the formula above, those years when januari 3 is on a sunday you get an incorrect date. Use Januari 4 instead.
=DATE(C2;1;4)-WEEKDAY(DATE(C2;1;4);2)+7*(B2-1)+A2
C2=Year
B2=Week number
A2=Day of the week