Concatenate Function

[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

 

[Niek Otten]

Use TEXT(DATE(YEAR(B3),MONTH(B3),0),"mmmm-yy") instead of just Date etc

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel