+ Reply to Thread
Results 1 to 3 of 3

Random dates, working days only

  1. #1
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Random dates, working days only

    Hi

    I'm trying to come up with a way of randomly assigning a date of the month to a list of approx 55 names.
    The dates would need to correspond to a Monday-Friday and I need no more than 4 or 5 of the names having the same dates.
    I need this to be in 2 parts, one for the first 2 weeks of the month and the second for the last 2 weeks.
    Any ideas how I can do this? or is there something out there I can adapt?

    thanks

  2. #2
    Forum Contributor wakeupcall's Avatar
    Join Date
    02-29-2012
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    155

    Re: Random dates, working days only

    I think it might be much easier to assign a name to a workday rather than vice versa
    Liked the answer given? click * to say so

  3. #3
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Re: Random dates, working days only

    thanks, but I think I need it to work this way. any ideas how I can do it?

    thanks

+ 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. Help Working Out Relative Dates and Non Working Days
    By leungf in forum Excel General
    Replies: 0
    Last Post: 08-07-2012, 12:06 PM
  2. Dates and Working Days
    By improveddc in forum Excel General
    Replies: 1
    Last Post: 09-30-2009, 01:14 PM
  3. Replies: 7
    Last Post: 01-16-2009, 05:04 AM
  4. adding only working days to dates
    By bazooka in forum Excel General
    Replies: 2
    Last Post: 05-04-2006, 01:15 PM
  5. Counting Working Days Between Dates
    By runforestrun in forum Excel General
    Replies: 0
    Last Post: 02-21-2005, 11:43 AM

Tags for this Thread

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