nk18
04-05-2007, 01:51 AM
Hello,
Any ideas on how to achieve the following: I have a list of names and individual dates and what I would like to do is convert them to a 'names' column, a 'to' column and a 'from' column where the the 'to' and 'from' columns are the dates that are consecutive weekdays (weekends aren't included so a Friday & Monday would count as consecutive). Here is some sample data:
Original:
Name Date
Olivia 03-Jan-06
Clare 05-Jan-06
Clare 06-Jan-06
Stuart 06-Jan-06
Stuart 09-Jan-06
Stuart 10-Jan-06
Converted to:
Name To From
Olivia 03-Jan-06 03-Jan-06
Clare 05-Jan-06 06-Jan-06
Stuart 06-Jan-06 10-Jan-06
Thanks for any help.
Any ideas on how to achieve the following: I have a list of names and individual dates and what I would like to do is convert them to a 'names' column, a 'to' column and a 'from' column where the the 'to' and 'from' columns are the dates that are consecutive weekdays (weekends aren't included so a Friday & Monday would count as consecutive). Here is some sample data:
Original:
Name Date
Olivia 03-Jan-06
Clare 05-Jan-06
Clare 06-Jan-06
Stuart 06-Jan-06
Stuart 09-Jan-06
Stuart 10-Jan-06
Converted to:
Name To From
Olivia 03-Jan-06 03-Jan-06
Clare 05-Jan-06 06-Jan-06
Stuart 06-Jan-06 10-Jan-06
Thanks for any help.