Cant quite get this formula to work:

[CarolineHedges]

="Nav as at"&TEXT(EOMONTH(Menu!E5);"dd mmmm yyyy")

Its returning a #N/A

The value in cell Menu!E5 is 30/06/2006. Although I have formatted thi
cell so that the date appears as 30 June 2006.

Sometimes this does work, but it isn't now. Is there an error with th
formula or could it be something to do with my settings?

Thank

 

[Niek Otten]

Hi Caroline,

EOMONTH needs one more argument:

="Nav as at"&TEXT(EOMONTH(Menu!E5;0);"dd mmmm yyyy")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|
| ="Nav as at"&TEXT(EOMONTH(Menu!E5);"dd mmmm yyyy")
|
| Its returning a #N/A
|
| The value in cell Menu!E5 is 30/06/2006. Although I have formatted this
| cell so that the date appears as 30 June 2006.
|
| Sometimes this does work, but it isn't now. Is there an error with the
| formula or could it be something to do with my settings?
|
| Thanks
|
|
| --
| CarolineHedges
| ------------------------------------------------------------------------
| CarolineHedges's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35705
| View this thread: http://www.excelforum.com/showthread.php?threadid=566544
|

 

[CarolineHedges]

Thank you!