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.
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
Thats great. Thanks tiger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks