Formula needed for date range

A5 is 1st Date
A90 is 2nd Date (2nd date is always 14 days later than A5 Date)

Text and Format wanted is
Dates: 04/11/05 - 04/25/05

Here is a formula that will give you the text of what you asked for.

=TEXT(A5, "mm/dd/yy") &" - " & TEXT(A5+14, "mm/dd/yy")

Note that this formula returns a text string not a date that Excel can
interpret...without a little bit of work...

HTH

"klt" wrote:

> A5 is 1st Date
> A90 is 2nd Date (2nd date is always 14 days later than A5 Date)
>
> Text and Format wanted is
> Dates: 04/11/05 - 04/25/05

One way:

=TEXT(A5,"mm/dd/yy - ") & TEXT(A5+14,"mm/dd/yy")

In article <3F77B84C-3214-4A25-B01A-FFCEADAB3956@microsoft.com>,
klt <klt@discussions.microsoft.com> wrote:

> A5 is 1st Date
> A90 is 2nd Date (2nd date is always 14 days later than A5 Date)
>
> Text and Format wanted is
> Dates: 04/11/05 - 04/25/05

Thank you Jim. I've been working on this forever. I'm not very good with
formulas. I really appreciate your response.

klt

"Jim Thomlinson" wrote:

> Here is a formula that will give you the text of what you asked for.
>
> =TEXT(A5, "mm/dd/yy") &" - " & TEXT(A5+14, "mm/dd/yy")
>
> Note that this formula returns a text string not a date that Excel can
> interpret...without a little bit of work...
>
> HTH
>
> "klt" wrote:
>
> > A5 is 1st Date
> > A90 is 2nd Date (2nd date is always 14 days later than A5 Date)
> >
> > Text and Format wanted is
> > Dates: 04/11/05 - 04/25/05

=TEXT(A5,"mm/dd/.yy")&" - "&TEXT(A90,"mm/dd/yy")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"klt" <klt@discussions.microsoft.com> wrote in message
news:3F77B84C-3214-4A25-B01A-FFCEADAB3956@microsoft.com...
> A5 is 1st Date
> A90 is 2nd Date (2nd date is always 14 days later than A5 Date)
>
> Text and Format wanted is
> Dates: 04/11/05 - 04/25/05

Thank you JE.

"JE McGimpsey" wrote:

> One way:
>
> =TEXT(A5,"mm/dd/yy - ") & TEXT(A5+14,"mm/dd/yy")
>
> In article <3F77B84C-3214-4A25-B01A-FFCEADAB3956@microsoft.com>,
> klt <klt@discussions.microsoft.com> wrote:
>
> > A5 is 1st Date
> > A90 is 2nd Date (2nd date is always 14 days later than A5 Date)
> >
> > Text and Format wanted is
> > Dates: 04/11/05 - 04/25/05
>