| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
End of Month Function
I write an formula by use EOMONTH function and it return #NAME? to me and I
aready install Analysis Tools - Add In and restart the computer alread. But it still doesn't work. Could any one help please. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
End of Month Function
What happens if you select that cell with the =eomonth() formula
then hit F2 (to edit) followed by Enter If you have lots of these, maybe you could just select all the cells edit|Replace what: = (equal sign) with: = (same equal sign) replace all Excel will see it as a change and reevaluate each formula. Tony wrote: I write an formula by use EOMONTH function and it return #NAME? to me and I aready install Analysis Tools - Add In and restart the computer alread. But it still doesn't work. Could any one help please. Thank you. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
End of Month Function
Thanks Dave, it works.
"Dave Peterson" wrote: What happens if you select that cell with the =eomonth() formula then hit F2 (to edit) followed by Enter If you have lots of these, maybe you could just select all the cells edit|Replace what: = (equal sign) with: = (same equal sign) replace all Excel will see it as a change and reevaluate each formula. Tony wrote: I write an formula by use EOMONTH function and it return #NAME? to me and I aready install Analysis Tools - Add In and restart the computer alread. But it still doesn't work. Could any one help please. Thank you. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
| When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
| =Month function in Excel gives incorrect month | New Users to Excel | |||
Hybrid Mode
