Date Range in Excel

[MRobbins]

I need to write a code for VBA that displays the first and last day of the year. Basically it will need to return the follwing into a cell in Excel,

January 1, YYYY - December 31, YYYY

Where YYYY will be the current year. I'm not sure how to make it only change the year. Thanks!

[missinglinq]

In the Formula Box for the cell, place this:

="January 1, " &YEAR(TODAY( )) & "-" & "December 31, " & YEAR(TODAY())

Linq ;0)>