IF ISBLANK formula

[kwillo]

[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]Original
[/TD]
[TD]Revised
[/TD]
[TD]Days Overdue
[/TD]
[/TR]
[TR]
[TD]12/2/19
[/TD]
[TD]31/3/19
[/TD]
[TD]X
[/TD]
[/TR]
[TR]
[TD]31/12/19
[/TD]
[TD][/TD]
[TD]X
[/TD]
[/TR]
</tbody>[/TABLE]





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