+ Reply to Thread
Results 1 to 2 of 2

Formula for Friday 14 days from start date, but closest to 15th or 30th

  1. #1
    Registered User
    Join Date
    09-09-2003
    Posts
    12

    Formula for Friday 14 days from start date, but closest to 15th or 30th

    I have a formula that will take a start date, add 14 days and find the closest Friday to that new date.

    Please Login or Register  to view this content.
    Is there any way to make a formula that will take P1, add 14 days and then find the closest Friday to the 15th or 30th of the month (whichever is the smaller difference). Also if P1 + 14 days is the 15th or 30th then that should be the date.

    Side note, for February I suppose it would have to be the 28th or 29th.

    Thanks

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Formula for Friday 14 days from start date, but closest to 15th or 30th

    Hello SiRCYRO,

    Your initial formula doesn't actually find the nearest Friday to P1+14.....it finds the first Friday on or after P1+14 which isn't the same thing.

    Some examples would be nice, if P1 is April 10th 2013, for example, what date do you want the formula to return and why?
    Audere est facere

+ 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