Chart Title with Formula

  • Thread starter Thread starter mimi
  • Start date Start date
M

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
 
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
 
Back
Top