2025 January Calendar Excel Cell Value Not Updating. In a3, enter the formula =workday.intl(a2, 1) if you also want to take public holidays into account, create a list of all public holidays and. Normally, after entering in the values in these 2 other cells, the formula cell updates automatically when enter.

Your 12 monthly sumifs formulae will all automatically refer to. First step is creating the variables.