| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Range of Dates
My example had a math error due to issues I seem to have with copy/
paste ;-) Example was meant to imply... Block 1 = 5 consecutive days Block 2 = 1 day Block 3 = 5 consecutive days Block 4 = 4 consecutive days Total days = 14 Blocks generated in this fashion would imply Employee 1 is taking vacation on 4 seperate occasions. (ie, 1 week, 1 day, 1 week, 4 days). For the sake of argument... assumption is weekdays. Thanks for pointing out the error. - MH On Apr 27, 1:46*pm, Jay wrote: In your example (eg, 5 consecutive days, 1 day, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I generate a list of random dates from dates I specify | Excel Worksheet Functions | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| random dates showing up in userform | Excel Programming | |||
| How to generate a random list of weekDAYS between two dates? | Excel Worksheet Functions | |||
| How do I generate random numbers using dates in excel? | Excel Worksheet Functions | |||
Threaded Mode
