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