Formula needed for date range
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
|