Counting Dates

  • Thread starter Thread starter Riyaz
  • Start date Start date
R

Riyaz

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?
 
This is probably what you are looking for...

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

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Date Count 2
Count Dates & Return as % 2
How to Populate Data from a table to another 0
Excel Formula - Count Dates from another Sheet 8
Count with conditions? 8
Really counting DATES 15
Count until condition is met and then retain final count 2
how to count number of days between 2 dates? 10

Back
Top