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 H
- if column I states Yes then I'd like a date inserted into Due date column H = received date plus 5 working days. So if received date is 1st November 2024 (01/11/2024) the 5th working day date expected is 8th November 2024 (08/11/2024)
- If column I states no then I'd like a date inserted into Due date column H = received date plus 20 working days. So if received date is 1st November 2024 (01/11/2024) the 20th working day date expected is 29th November 2024 (29/11/2024)
- If column I is blank then keep as blank
Thanks in advance if you can help
7 Replies
Thank you, sorry so if it was blank or NA , to return NA
Trying again! Now I changed the file name just to be sure.
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") )
Hello,
This file looks the same? Could you attach again please?
Perhaps like this (see attached) and provided you have a modern Excel version.
