Counting Dates

Riyaz · Jul 7, 2008

I need to count days between 2 dates in 2 cells. Like B:2-B:1. In case B2 is
empty i need that to be counted as on today-system date. Can you help on that?

Rick Rothstein \(MVP - VB\) · Jul 7, 2008

This is probably what you are looking for...

=IF(B2="",TODAY()-B1,B2-B1)

Rick

Bob Phillips · Jul 7, 2008

=IF(B2="",TODAY(),B2)-B1

Riyaz · Aug 20, 2008

Thank you so much Bob

Bob Phillips said:
=IF(B2="",TODAY(),B2)-B1

--
__________________________________
HTH

Bob

Counting Dates

Riyaz

Rick Rothstein \(MVP - VB\)

Bob Phillips

Riyaz