Good morning all,
Happy Friday!
I need some assistance with a formula I'm not sure if I need a nested if or if I can use an if or statement. I have two columns with dates in. A third column will calculate how many days have past/not yet past. I need a formula to check the second column first if there is a date in that cell then it needs to calculate the days otherwise it needs to calculate based on the date from the first cell. There will always be a date in the first column but not necessarily a date in the second column.
Any advice would be greatly appreciated!
Thank you
<tbody>
</tbody>
Happy Friday!
I need some assistance with a formula I'm not sure if I need a nested if or if I can use an if or statement. I have two columns with dates in. A third column will calculate how many days have past/not yet past. I need a formula to check the second column first if there is a date in that cell then it needs to calculate the days otherwise it needs to calculate based on the date from the first cell. There will always be a date in the first column but not necessarily a date in the second column.
Any advice would be greatly appreciated!
Thank you
Column 1 - Date | Column 2 - Date | Column 3 - Overdue/Not yet due |
01/01/2018 | 03/02/2018 | X |
31/01/2018 | X |
<tbody>
</tbody>