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.