- May 8, 2018
- 11,719
Evening all, wonder if anyone can help.
I am trying to write a formula to capture the next scheduled date in a range (note the range isn’t a table and will be on the same row all be it columns apart in the actual version - don’t know if this is an issue itself?
The example I’ve attached below shows the formula and the result (00/01/1900) rather than the expected outcome of 01/12/2020.
Can anyone help and confirm where I am going wrong?
Thanks
Sent from my iPhone using Tapatalk
I am trying to write a formula to capture the next scheduled date in a range (note the range isn’t a table and will be on the same row all be it columns apart in the actual version - don’t know if this is an issue itself?
The example I’ve attached below shows the formula and the result (00/01/1900) rather than the expected outcome of 01/12/2020.
Can anyone help and confirm where I am going wrong?
Thanks

Sent from my iPhone using Tapatalk