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