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
|