Thank you, Martin. I believe this is exactly what I need. I'm not overly
concerned about the leap year stuff. This is needed to calculate rough times
of year for beach closures among the various beaches in Macomb County, MI.
It's meant to lead to averages for closure dates, standard deviations, and
t-tests to see if the time of the year for closings really does vary among
the various beaches. I was using a DATEDIF function, and that's ok for one
year, but when you have thousands of dates over a ten-year timespan, it
becomes a rather daunting prospect. This is a significant improvement over
the function I was using. Thanks again.

"MartinW" wrote:

And following that
=TODAY()-DATE(YEAR(TODAY()),1,0)
Should work in any year.

HTH
Martin