generating date range from current date

[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.

[Richard Buttrey]

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.

Please Login or Register  to view this content.

Rgds

[daddylonglegs]

Try

="January, 01 "&YEAR(TODAY())&TEXT(TODAY()," to mmmm, dd yyyy")