Concatenate Function

  • Thread starter Thread starter Dnk
  • Start date Start date
D

Dnk

At the end of the following formula the date is displayed as 38017.
The date in B3 is Feb 9 2004. I need to format the date to "mmm-yy"
=CONCATENATE("Average Daily offtake based on consumption for the month
of ",DATE(YEAR(B3),MONTH(B3),0))
Can anyone please assist?
DK
 
Use TEXT(DATE(YEAR(B3),MONTH(B3),0),"mmmm-yy") instead of just Date etc

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

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

Loop through date range, but skip down to next year 18
Locking/unlocking cells based on column headers 5
function tweak? 5
Date format. 1
Date Variable 6
Date Issue 1
Excel Help with dates 2
Concatenate error and Date Format Error 3

Back
Top