Chart Title with Formula

[mimi]

I have created a chart title, whcih I want to automate
with the following formula:

=IF(ISBLANK(A1),A2&" charges to "&A3&" compared to rates
surveyed in "&D1&" including delivery and
collection",A2&" charges to "&A1&" compared to rates
surveyed in "&D1&" including delivery and collection")

Everything comes through perfectly from the corresponding
worksheet apart from the date (being D1), which is shown
as 38169.

This should read July 2004 (cell formatted to mmmm yyyy,
which is pulled through from another cell formated as dd
mmmm yyyy.

Can anyone help?

Many thanks

 

[Andy Pope]

Hi mimi,

Try using the TEXT() function.

=IF(ISBLANK(A1),A2&" charges to "&A3&" compared to rates
surveyed in "&D1&" including delivery and
collection",A2&" charges to "&A1&" compared to rates
surveyed in "& TEXT(D1,"mmmm yyyy")&" including delivery and collection")

Cheers
Andy