Thread: Cant quite get this formula to work:
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CarolineHedges CarolineHedges is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote