+ Reply to Thread
Results 1 to 2 of 2

Calculating a Date Based on Year, Week Number and Day of the Week

  1. #1
    amy
    Guest

    corresponding dates

    If I type in the date in cell d10, what formula can I use in cells F-L10?

  2. #2
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Calculating a Date Based on Year, Week Number and Day of the Week

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1