Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have to calculate column "Days to Action" based "original Target date". Incase Original target date is revised then i need to consider "Revised Target Date".
Can some one assist me to achive this.
Original Target Date | Revised Target Date | Days to Action |
---|---|---|
12/01/2016 | -11 | |
11/01/2016 | -41 | |
11/01/2016 | 12/01/2016 | -5 |
11/01/2016 | 12/31/2016 | 25 |
12/31/2016 | 26 | |
12/21/2016 | 16 |
Many thanks in advance
Deepak
how do you calculate days to action? can you post complete sample in excel
Hi,
Please see attached.
Hope it helps!
Try
=if(len(RevisedTargetDate)>0,RevisedTargetDate-Today(),OriginalTargetDate-Today())