Hi all, pls see the attached example.
Why does e.g. the workday function allow dates to be array-entered like this {"1/1/2000"} while XNPV does not but does only accept the serial number equivalent of that date?
Thanks
Hi all, pls see the attached example.
Why does e.g. the workday function allow dates to be array-entered like this {"1/1/2000"} while XNPV does not but does only accept the serial number equivalent of that date?
Thanks
Good question. Who knows why MS allow such inconsistencies within their function development?
Regards
It's not the only case, of course. With A1 containing the date 22/11/2022:
=A1="22/11/2022"
and
=SUMPRODUCT(N(A1="22/11/2022"))
return FALSE and 0 respectively, whereas
=COUNTIFS(A1,"22/11/2022")
is happy to 'interpret' the text string passed as the criteria as a date.
Regards
Didn't think this would work but does: =XNPV(10%,{0,1000},DATEVALUE({"22/11/2022","25/11/2022"}))
Hmm, ok.
Thanks XOR LX.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks