Compatibility functions can still be used in later versions of Excel to ensure backward compatibility. However, Microsoft recommends that users deploy the newer functions (compatibility function replacements) when backward compatibility isn’t required. Not all new functions with similar names indicate compatibility functions. For example, the NETWORKDAYS function, which calculates workdays between dates, is not listed as a compatibility function even though NETWORKDAYS.INTL is a newer function with the same purpose. The NETWORKDAYS.INTL simply provides more flexibility, allowing users to customize which days of the week are treated as weekends (i.e. non-work days). Microsoft maintains a list functions with a category for compatibility functions. Author
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
