Original | Revised | Days Overdue |
12/2/19 | 31/3/19 | X |
31/12/19 | X |
<tbody>
</tbody>
Good morning all,
I wonder if you could help me out with a query. I have a table with two dates, an original date and a revised date. I need the formula which looks at the revised date first and counts the number of days between this and TODAY() but if the cell is blank I want it to look at the original date instead and count the number of days between this and TODAY().
Can anyone help?
Many thanks
Keri