=TEXT(A1-3,"dd/mm/yy")&" - "&TEXT(A1-1,"dd/mm/yy")

second part

=DATE(YEAR(A1),MONTH(A1),DAY(A1)-45)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



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