+ Reply to Thread
Results 1 to 3 of 3

Specific Weekday within date range

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Specific Weekday within date range

    Hello,

    I'm using Excel 2007 and somewhat limited when it comes to formulas.

    I have a spreadsheet with two sets of date ranges that I need to specify a random date between the two; however, I need that random date to only fall on a Sunday.

    My spreadsheet looks like this:

    Column F = Start Date
    Column G = End Date

    I need in Column "H" a random date; but that date can only fall on a Sunday
    I need in Column "I" a second random date that cannot duplicate any which are in Column H that too falls on a Sunday.

    Is this possible?

    Many Thanks!

    excel forum.jpg

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,844

    Re: Specific Weekday within date range

    Nicksmomma,

    In the future, please don't post a picture - post the actual spreadsheet, minus any confidential information.

    But to answer your question, see my attached workbook and see if it does what you want.

    It uses helper columns to determine the Sundays between the earliest date in your list and the latest date in your list (Column L).
    Column M displays dates that aren't chosen in column H, from column L, and Column N produces a list of those same unused dates, but without blanks. Had to do this so the formulas in column I work correctly, since they can't be duplicates of any dates in column H.

    - Moo
    Attached Files Attached Files
    Last edited by Moo the Dog; 10-29-2013 at 02:40 PM.

  3. #3
    Registered User
    Join Date
    10-29-2013
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Red face Re: Specific Weekday within date range

    Moo,

    I cannot thank you enough; you accomplished exactly what I needed. I have no idea what you did, but thank you!

    Oh, and thanks for the tip on uploading the excel file. Newbie mistake.

    Have a great day!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If date = weekday, ignore cell range
    By rachel.dudley in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-04-2013, 06:41 AM
  2. Copy and paste specific range to date specific range in alternate sheet
    By alanalmarza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 08:29 AM
  3. [SOLVED] Need help w/formula to find to the next weekday (Tuesday) after 7 years from specific date
    By sfmauldin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-04-2012, 08:17 PM
  4. Round Down Dates to Specific Weekday
    By torresk in forum Excel General
    Replies: 7
    Last Post: 05-05-2010, 02:10 PM
  5. Next Specific Weekday
    By Sir08 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-25-2009, 02:56 PM

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