dmxcasper2
Board Regular
- Joined
- Mar 21, 2012
- Messages
- 65
Problem Statement:
For Row 2 I'm using =today()-A1
For Row 3 I need a a formula that perform the following logic statement under these conditions:
Is it possible to keep Column values a positive integers.
<tbody>
</tbody>
For Row 2 I'm using =today()-A1
For Row 3 I need a a formula that perform the following logic statement under these conditions:
- If Column B is blank then calculate using =today()-A1
- If Column B has a date then calculate Column A - Column B
- If Column A has a non date value like "TBA", then Column C should remain blank
Is it possible to keep Column values a positive integers.
Column A | Column B | Column C - Aging |
11/05/2018 | 12/01/2018 | 26 |
11/05/2018 | 30 |
<tbody>
</tbody>