Thread: Counting Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Riyaz Riyaz is offline
external usenet poster
 
Posts: 4
Default 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?