IF ISBLANK formula

[kwillo]

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

 

[PCL]

Re: Please can you help with IF ISBLANK formula?

=IF(B2="",INT(TODAY()-A2),INT(TODAY()-B2))
Difference between to day and 31/12/19 will be negative !!!

 

[kwillo]

Re: Please can you help with IF ISBLANK formula?

=IF(B2="",INT(TODAY()-A2),INT(TODAY()-B2))
Difference between to day and 31/12/19 will be negative !!!

Worked perfectly, thank you!

 

[PCL]

Re: Please can you help with IF ISBLANK formula?

Good news, you're welcome