Nested if or if or formula

[kwillo]

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

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>

 

[njimack]

Re: Nested if or if or forumula needed?

If column B will always either be blank or greater than column A, you can use =TODAY()-MAX(A2,B2)

 

[kwillo]

Re: Nested if or if or forumula needed?

Thanks Neil that has worked perfectly, what do I need to add if I want it to return a blank cell if there is nothing in the first two columns?