| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the work sheet name in a formula by using cell reference | Excel Worksheet Functions | |||
| Why does this Formula work? | Excel Worksheet Functions | |||
| Formula do not work until edited | Excel Discussion (Misc queries) | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
