Which Excel functions work in user-defined functions ?
Partly through time-consuming trial and error, and partly through asking questions, I have learned that the built-in DATE() function in Excel doesn’t work in a user-defined function. But DATESERIAL() does the same thing and DOES work in a user-defined function but doesn’t work when directly entered into an Excel spreadsheet.
Is there a list anywhere of which built-in functions work and don’t work in both Excel and user-defined functions? or am I missing something here?
Thanks.
Bookmarks