Let's say the date is in A1

Then

="Sales Report " & TEXT(A1,"mmmm") & IF(DAY(A1)<16," 1-15"," 16 - " &
DAY(DATE(YEAR(A1),MONTH(A1)+1,0)))

will produce
Sales Report April 1-15
for 4/12/2006

and produce
Sales Report April 16 - 30
for 4/20/2006
--
Gary's Student


"ldan122000" wrote:

I would like to use a formula to display the following:

"Name of Report" October 1 - 15 as the date, then on the next sheet,

"Name of Report" October 16 - 31

But also make adjustments when the months are shorter, such as November 30.

Thanks, any help would be appreciated.