I was searching how to enter more than one date in a single excel sheet, but
failed to find an answer. Here is my situation : I have a two days training
at my job, and we use excel to keep track of the trainings.

Now, let's pretend that the training took place May 1st and 2nd 2006. I want
to enter those 2 dates in a cell, but I also want to be able to sort the
trainings by date, and the only way (that I know of) to put May 1-2 2006 in a
cell is to format it as text. But as we all know, doing that will screw your
chronological sorting.

We should be able to enter 2 dates in a cell with the option of sorting it
chronologically without a hassle.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

If you enter the starting date in column A, for example, and the ending
date in column B, you can perform a multi-column sort by instructing
Excel to sort first on column A and then on column B. Will this
provide the functionality you need?

Unfortunatly, no.

The date column isn't only used for sorting, it is also used for making
certificates. By doing a mail merge, I can quickly do certificates using
words, requiring a little data tweeking to make sure the format is ok
(example, replace "May 1, 2006" by "May 1 and 2, 2006"). If i had a starting
date and an ending date column, the data will still need some tweeking before
the certificates are issued, since a mail merge wouldn't do the job.

Why can't it be so easy :) haha

It actually is easy: with separate dates in columns A and B, for
instance, enter a formula in column C that will generate the text
string you need for the certificates. It might look like this:
=CHOOSE(MONTH(A1),"January", "February", "March", "April", "May",
"June", "July", "August", "September", "October", "November",
"December")&" "&DAY(A1)&" and "&DAY(B1)&", "&YEAR(A1)

The newsgroup has wrapped that entry- in the formula bar it should not
wrap too many times.

If you enter the date consistently using a nice format, it may work for you:

2006-05-28--2006-05-29

Something that is treated as text, but can be sorted the way you want.

m_a_turcotte wrote:

I was searching how to enter more than one date in a single excel sheet, but
failed to find an answer. Here is my situation : I have a two days training
at my job, and we use excel to keep track of the trainings.

Now, let's pretend that the training took place May 1st and 2nd 2006. I want
to enter those 2 dates in a cell, but I also want to be able to sort the
trainings by date, and the only way (that I know of) to put May 1-2 2006 in a
cell is to format it as text. But as we all know, doing that will screw your
chronological sorting.

We should be able to enter 2 dates in a cell with the option of sorting it
chronologically without a hassle.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson