IF ISBLANK formula

kwillo

New Member
Joined
Sep 10, 2015
Messages
17
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
Joined
Jul 15, 2008
Messages
1,317
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
Joined
Sep 10, 2015
Messages
17
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
Joined
Jul 15, 2008
Messages
1,317
Re: Please can you help with IF ISBLANK formula?

Good news, you're welcome
 

Forum statistics

Threads
1,077,664
Messages
5,335,570
Members
399,025
Latest member
alce

Some videos you may like

This Week's Hot Topics

Top