software

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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

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 quot;May 1, 2006quot; by quot;May 1 and 2, 2006quot;). 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),quot;Januaryquot;, quot;Februaryquot;, quot;Marchquot;, quot;Aprilquot;, quot;Mayquot;,
quot;Junequot;, quot;Julyquot;, quot;Augustquot;, quot;Septemberquot;, quot;Octoberquot;, quot;Novemberquot;,
quot;Decemberquot;)amp;quot; quot;amp;DAY(A1)amp;quot; and quot;amp;DAY(B1)amp;quot;, quot;amp;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:
gt;
gt; I was searching how to enter more than one date in a single excel sheet, but
gt; failed to find an answer. Here is my situation : I have a two days training
gt; at my job, and we use excel to keep track of the trainings.
gt;
gt; Now, let's pretend that the training took place May 1st and 2nd 2006. I want
gt; to enter those 2 dates in a cell, but I also want to be able to sort the
gt; trainings by date, and the only way (that I know of) to put May 1-2 2006 in a
gt; cell is to format it as text. But as we all know, doing that will screw your
gt; chronological sorting.
gt;
gt; We should be able to enter 2 dates in a cell with the option of sorting it
gt; chronologically without a hassle.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson