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


"CarolineHedges" <CarolineHedges.2bsztu_1154338702.1228@excelforu m-nospam.com wrote in message
news:CarolineHedges.2bsztu_1154338702.1228@excelfo rum-nospam.com...
|
| ="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...o&userid=35705
| View this thread: http://www.excelforum.com/showthread...hreadid=566544
|