Forum Discussion

Jna3276's avatar
Jna3276
Tin 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
Tin 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") )