Can I get excel to count a date range? but slightly more complicated

**daybreak** · 06-07-2011, 12:49 PM

Our company needs to be able to tell how long our clients have been with us (in days), either current or past so what I need excel to do is calculate the days in a date range and, if there is no end date, calculate the range to the current day's date. I know that it can be done for a simple range(with begin and end dates), and also for a range to NOW(from a start date to now), but can they be done together? Any help would be greatly appreciated.

**tigeravatar** · 06-07-2011, 01:15 PM

daybreak,

Welcome to the forum. See attached for an example of what you're trying to do. The formula is:
=IF(C2="",TODAY()-B2,C2-B2)

Hope that helps,
~tigeravatar