Forum Discussion
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 ...
Thanks!
If it had NA, in the column with No, Yes and you want that to return NA how would the forumla change?
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") )