If I type in the date in cell d10, what formula can I use in cells F-L10?
If I type in the date in cell d10, what formula can I use in cells F-L10?
Problem:
Calculating a date using the relevant numbers for day of the week, week number, and year number.
Solution:
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks