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
|