| 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 |
| 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 | |||
Threaded Mode
