Min /Max Date Into String

  • Thread starter Thread starter mdma
  • Start date Start date
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?
 
="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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arrays, Dates & Blank Cells 3
formula to display the max (or min value) for an entire column, basedon value in an individual cell 1
Min and Max Function 4
date range in one cell 2
Using Min & Max to sort log times. 4
How to enter start and end date/time in excel based on some specific value. 7
Show column header in addition to min/max result 5
Data Validation and Current Date ? 4

Back
Top