Cant quite get this formula to work:
 

="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

Cant quite get this formula to work:
 

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
|

Cant quite get this formula to work:
 

Thank you!


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=566544