# aging a date in column A unless there is a value in column B

1. ## aging a date in column A unless there is a value in column B

Hello,

I need help coming up with a formula. In column A I have various dates that a customer began doing business with us. In column B is the date that that customer began generating revenue. I need to put a formula in column C that calculates the number of days between now and when the customer begain doing business with us (column A) unless there is a date in column B.

Book1.xlsx

In this example I would need a value returned in column C on rows 3, 4, 5, and 7 but not on 2 and 6.

Any help would be greatly appreciated!

2. ## Re: aging a date in column A unless there is a value in column B

Maybe this...

Entered in C2 and copied down:

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

3. ## Re: aging a date in column A unless there is a value in column B

That is a good start, but the column still displays a value even if there is something in column B.

4. ## Re: aging a date in column A unless there is a value in column B

I figured it out. The formula I needed was =IF(and(A2>0, B2=""), TODAY()-A2, "")

Thanks for the help!

5. ## Re: aging a date in column A unless there is a value in column B

Good deal. Thanks for the feedback!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1