Date Range displayed in header
Thanks for the reply. That works great in a cell on the worksheet, but how do
I get it to display in the header?
Thanks in advance.
BD
"Dave Peterson" wrote:
=text(min(a1:a10),"m/d/yyyy") & " - " & text(max(a1:a10),"m/d/yyyy")
Bdadmin wrote:
I am attempting to put the range of MIN and MAX dates pulled from a column. I
would like it to look like:
Date Range: 9/6/2006 - 10/26/2006
from a column like this:
Date
09/06/2006
09/06/2006
09/10/2006
10/12/2006
10/26/2006
Thanks in advance
BD
--
Dave Peterson
|