ExcelBanter - When save as another file, EDATE and XIRR functions return #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - When save as another file, EDATE and XIRR functions return #N/A (https://www.excelbanter.com/excel-worksheet-functions/151490-when-save-another-file-edate-xirr-functions-return-n.html)

nguyensea

When save as another file, EDATE and XIRR functions return #N/A

Please help. Sometimes the functions work, sometimes they don't. When they
don't, if I save the file as another file (in Excel 2007 or earlier version),
EDATE and XIRR disappear and are replaced by #N/A. I already update Add-in
Toolpak. Thanks.

All times are GMT +1. The time now is 04:39 AM.