I am trying to make a time table based of a completion date A1 for specific
tasks.

Some completion dates have a range of dates. Here is what i need to do. If
cell A1 is 12/1/07 i want a cell to return "9-1-07 to 10-1-07". I have no
problem getting cells to return a simple 9-1-07 or 10-1-07 but when i try to
use concatenate or $ Excel only displays the date value ie 39249 for 6/16/07.
So instead of getting 9/1/07 to 10/1/07 to display in cell i would get
39429 to 39459 or something to that effect. Any suggestions.

Also i am currently setting up formulas to display say 45 days before
completion date at =date(year(A1), month(A1)-1, day(A1)-15. However, this
doesn't seem totally accurate. Any suggestions.