Results 1 to 7 of 7

Find date from year and week number

Threaded View

  1. 07-16-2014, 06:35 AM #1
    pnperl
    pnperl is offline
    Registered User
    Join Date
    04-16-2011
    Location
    India
    MS-Off Ver
    Excel 365
    Posts
    10

    Post Find date from year and week number

    How to find exact date from year and week number.
    I have googled and found many formulas but none of them is working correctly.

    One of them was as below.

    Formula: copy to clipboard 
    =DATE(C2,1,1)+(B2*7)-(7-A2)+WEEKDAY(DATE(C2,1,1)+(B2*7)-(7-A2),2)


    A1=nth Day
    B1=Week no
    C1=Year
    E1=FORMULA/Date
    Last edited by pnperl; 07-17-2014 at 01:58 AM. Reason: File corrected
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find last 12 values based on week number/year
    By pytheus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2014, 05:14 AM
  2. [SOLVED] Determine Week Start Date From Year And Number
    By SalientAnimal in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-23-2013, 07:51 AM
  3. Convert date to week number for fiscal year starting July 25
    By ARayburn in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-15-2013, 10:07 AM
  4. Get Date from Week Number and Year ( Fiscal Calendar)
    By tantcu in forum Excel General
    Replies: 6
    Last Post: 05-08-2013, 01:46 PM
  5. Calculating a Date Based on Year, Week Number and Day of the Week
    By amy in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 11:42 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1