Adding one working day (no blanks)

Kirsteen Leckie

Hi,

I am trying to add a day onto a date generated from a previous date - However, it needs to be a working day and the cells with no previous date need to stay blank until the previous date is entered... i am currently using - =[Expected Final or QA Approval]@row + 1 - however the cells with no date in the previous cells are generating a "1" result - i need this to be blank.

Confused.com....

Paul Newcome

Try this:

=IFERROR(WORKDAY([Expected Final or QA Approval]@row, 1), "")

Paul Newcome

Try this:

=IFERROR(WORKDAY([Expected Final or QA Approval]@row, 1), "")

Kirsteen Leckie

@Paul Newcome Perfect! thank you!

Paul Newcome

Happy to help. 👍️