Formula needed for date range
Thank you JE.
"JE McGimpsey" wrote:
One way:
=TEXT(A5,"mm/dd/yy - ") & TEXT(A5+14,"mm/dd/yy")
In article ,
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
|