+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Formula to return Fri date if M, T, W. Return following Fri date if Thurs or Fri

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007
    Posts
    2

    Formula to return Fri date if M, T, W. Return following Fri date if Thurs or Fri

    I have a date in cell M3, I need cell N3 to return the following Friday date.

    Here is the formula I used:

    =M3-WEEKDAY(M3,3)+IF(AND(WEEKDAY(M3,3)>=5,WEEKDAY(M3,2)<=5),9,11)

    HOWEVER, I if the date in cell M3 is on a Monday Tuesday or Wednesday, I need the Friday date to be of that week.

    If the date in cell M3 is on a Thursday or Friday, I need the Friday date to be that of the following week.

    Examples:
    M3 = 7/26/10 N3 needs to return 7/30/10
    M3 = 7/29/10 N3 needs to return 8/6/10

    Patiently waiting your excel mastery assistance.

    Thank you.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Formula to return Fri date if M, T, W. Return following Fri date if Thurs or Fri

    A few routes

    =M3+CHOOSE(WEEKDAY(M3,2),4,3,2,8,7,6,5)

+ 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