dmxcasper2
Board Regular
- Joined
- Mar 21, 2012
- Messages
- 65
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date Action Was Opened[/TD]
[TD]Commitment Date[/TD]
[TD]Re-Commitment Date[/TD]
[TD]Late to Commitment Aging[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]11/15/2018[/TD]
[TD]12/10/2018[/TD]
[TD]12/12/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Problem Statement:
Today's Date minus (oldest date of Column B and C, if only one date exists in either of those columns, use that date.)
The sum of this calculation would be in cell D2.
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date Action Was Opened[/TD]
[TD]Commitment Date[/TD]
[TD]Re-Commitment Date[/TD]
[TD]Late to Commitment Aging[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]11/15/2018[/TD]
[TD]12/10/2018[/TD]
[TD]12/12/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Problem Statement:
Today's Date minus (oldest date of Column B and C, if only one date exists in either of those columns, use that date.)
The sum of this calculation would be in cell D2.