View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Formula needed for date range

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

--

HTH

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


"klt" wrote in message
...
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