Results 1 to 9 of 9

Week no return starting to date against year

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    372

    Week no return starting to date against year

    Dear Forum Leader,

    Week number extract starting to end date corresponding to the year.(Financial calendar)

    I am apply the following formula but return the date wrongly.

    E2=MAX(DATE(RIGHT(B3,2),1,1),DATE(RIGHT(B3,2),1,1)-WEEKDAY(DATE(RIGHT(B3,2),1,1),2)+(C3-1)*7+1)

    YEAR*****WEEKNO**RESULT FORMULA O END DATE

    ****20/03/2017 **** 17/12/1917
    Apr-17*****51 ****26/03/2017 **** 23/12/1917
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 04-11-2017, 09:23 AM
  2. [SOLVED] Get the date of saturday in a week from a week number / year
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2015, 06:56 PM
  3. [SOLVED] Show the week nukmber of todays date from a starting date
    By john dalton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2014, 05:27 AM
  4. 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
  5. Replies: 0
    Last Post: 01-21-2013, 08:46 AM
  6. [SOLVED] calculating a date using the day of the week as a starting point?
    By Simon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-12-2006, 09:35 AM
  7. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1