generating date range from current date

Hi, I have a function =Today() which shows current date, ie 03/14/2008. I want to take that function and create a date range from the begining of the year of current date. Like this:
'January, 01 2008 to March, 14 2008'
Any ideas how can this be done?
Thanks in advance.

Originally Posted by dexelguy

Hi, I have a function =Today() which shows current date, ie 03/14/2008. I want to take that function and create a date range from the begining of the year of current date. Like this:
'January, 01 2008 to March, 14 2008'
Any ideas how can this be done?
Thanks in advance.

="January 1, "&YEAR(C24)&" to "&CHOOSE(MONTH(TODAY()),"January","February","March","April","May","June","July","August","September","October","November","December")&", "&DAY(TODAY())&" "&YEAR(TODAY())

Rgds