Concatenate Function
 

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

Concatenate Function
 

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


"Dnk" wrote in message
om...
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