ExcelBanter - Counting Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting Dates (https://www.excelbanter.com/excel-discussion-misc-queries/193857-counting-dates.html)

Riyaz

Counting Dates

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\)[_831_]

Counting Dates

This is probably what you are looking for...

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

Rick

"Riyaz" wrote in message
...
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?

Bob Phillips[_3_]

Counting Dates

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

--
__________________________________
HTH

Bob

"Riyaz" wrote in message
...
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?

Riyaz

Counting Dates

Thank you so much Bob

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Riyaz" wrote in message
...
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?

All times are GMT +1. The time now is 10:50 PM.