Forum Discussion

Jna3276's avatar
Jna3276
Copper Contributor
Nov 19, 2024

Populate future date

Hi,   Is it possible to create a formula which inserts a future date, either 5 working days or 20 working days or blank   Sheet includes a received date, column G, the formula would be in column ...
excel
Formulas and Functions
  • Jna3276's avatar
    Jna3276
    Copper Contributor
    Nov 20, 2024

    Thanks!

    If it had NA, in the column with No, Yes and you want that to return NA how would the forumla change?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 20, 2024

      Variants

      =IF( I2= "", "",
  IF( I2 = "NA", "NA",
      WORKDAY.INTL(G2, 20*(I2="no") + 5*(I2="yes") )
) )

      or

      =IF( I2="", "", IFERROR( WORKDAY.INTL(G2, 20*(I2="no") + 5*(I2="yes") + (I2="NA"), I2<>"NA" ), "NA") )
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Nov 20, 2024

      Like so:

      =IF(I2="NA","NA",WORKDAY.INTL(G2,XLOOKUP(I2,{"no","yes"},{20,5},0)))

Resources