If the date is in cell A1 then:
="Receipts from:" & TEXT(A1,"mm-dd-yyyy")

--
Gary's Student


"SJ" wrote:

Hello!

Text = "Receipts from:"
Date = 10/5/06. (This date will in a different cell and will change every
month)

The decription I desire will be: "Receipts from: "1st to 5th October" or any
variation thereof as long as it shows the period

Thanks
SJ