Concatenate with the formula values

[Guest]

When I, concatenate the values of two cells, Cell A1 contains the text
"Payables for the month of " & Cell B1 Contains the formula Value of Date".

When Concatenated the two cells the value in cell B1 is shown in number
format and not in date format as displayed in the cell.

How to get the date format ?

Regards

 

[T. Valko]

Based on the string in A1: Payables for the month of

I'm assuming you want the month name from the date in cell B1

=A1&" "&TEXT(B1,"mmmm")

A1 = Payables for the month of
B1 = 3/10/2007

Result of formula = Payables for the month of March

If B1 is ever empty the result will be: Payables for the month of January

So, you might want to add some robustness to the formula:

=IF(COUNTA(A1:B1)<2,"",A1&" "&TEXT(B1,"mmmm"))

If either cell is empty the formula cell will remain blank.

Biff

 

[Guest]

=A1&TEXT(B1,"m/d/yyyy")