# IF ISBLANK formula

#### kwillo

##### New Member
 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

##### Well-known Member
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

##### New Member
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

##### Well-known Member
Re: Please can you help with IF ISBLANK formula?

Good news, you're welcome