Hi,
I have a spreadsheet where dates are put in then another cell then references the cell and then adds a predefined value.
For example - If A1 = 16-Oct and the value to add is 7 then this would return 23-Oct.
However, how can I then set up a formula that for when the value to add equals a Saturday or Sunday, that it rounds it up to the nearest Monday?
So my example would be - If A1 = 17-Oct and the value to add is 5 days then I don't want 22-Oct as this would be a Sunday but would want Mon 23-Oct?
Thanks
I have a spreadsheet where dates are put in then another cell then references the cell and then adds a predefined value.
For example - If A1 = 16-Oct and the value to add is 7 then this would return 23-Oct.
However, how can I then set up a formula that for when the value to add equals a Saturday or Sunday, that it rounds it up to the nearest Monday?
So my example would be - If A1 = 17-Oct and the value to add is 5 days then I don't want 22-Oct as this would be a Sunday but would want Mon 23-Oct?
Thanks