Min /Max Date Into String

M

mdma

I require as a header, Report From (min Date) to (max Date)

which i have acheived by :

="Summary Data For Period "&MIN(Data!B:B)&" To "&MAX(Data!B:B)

however the dates are returned as excel values rather than dates. How
can i format them as dates?
 
B

Bob Phillips

="Summary Data For Period "&TEXT(MIN(Data!B:B),"dd-mmm-yyyy")&" To
"&TEXT(MAX(Data!B:B),"dd-mmm-yyyy")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top