Forum Discussion

melissaw's avatar
melissaw
Copper Contributor
Jan 25, 2020

Excel 2013 compatibility with Excel 2016

We have a mix of Excel 2013 and Excel 2016 users at our workplace. We are running into compatibility issues.   For example, an Excel file created in Excel 2013 has working formulas. When this file ...
excel
melissaw's avatar
melissaw
Copper Contributor
Jan 25, 2020

LidiaMThanks for your reply. The sumifs formulas are linked to cell references. The dates are not hard keyed into the formulas.

LidiaM's avatar
LidiaM
MCT
Jan 25, 2020

melissaw And what about regional standards? Are they the same for 2013 and 2016 users?

  • melissaw's avatar
    melissaw
    Copper Contributor
    Jan 25, 2020

    LidiaMYes, regional standards are the same.

    • LidiaM's avatar
      LidiaM
      MCT
      Jan 25, 2020

      melissawCan you try DATE function? for example for 2019-31-12 in A1 use

      DATE(LEFT(A1;4);RIGHT(A1;2);MID(A1;6;2)).

       

      It should work in both cases.

Resources