I am showing a webpage where I list out where people will be out of the office. I want to get some feedback on which is a better format (obviously forget about the fact that you can't draw good tables on stackexchange :) )
| Name | Start Date | End Date | | Joe | 1 Jan 2014 | 8 Jan 2014 | | Bill | 29 Dec 2013 | 8 Jan 2014 | | Scott | 9 Jan 2014 | 3 Feb 2014 |
| Name | Start Date | End Date | | Joe | Jan 1, 2014 | Jan 8, 2014 | | Bill | Dec 29, 2013 | Jan 8, 2014 | | Scott | Jan 29, 2014 | Feb 3, 2014 |
| Name | Dates | | Joe | Jan 1st - 8th, 2014 | | Bill | Dec 29th, 2013 - Jan 8th, 2014 | | Scott | Jan 29th - Feb 3rd, 2014 |
I think I prefer Option 3 as it is the most succinct (only shows month or year twice if the values are different). But others have argued that it's harder to read because the start and end dates don't line up and you may at a later point want to sort by either the Start or End date column (no requirement to do that now). Just wanted to see if there was a best practice here.
The questions I guess come down to:
- One column or two columns (separate start and end date)
- Include the "th" and the "rd" or leave that out