You will need two dates (unless the start date is always the first of
the month) - assume these are in A1 and B1. Your formula is then:

="Receipts from: "&TEXT(A1,"mm/dd/yy")&" to "&TEXT(B1,"mm/dd/yy")

Hope this helps.

Pete

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