Calculate number of days

[dsharmaqv]

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

[vinieme12]

how do you calculate days to action? can you post complete sample in excel

[Anonymous · Accepted solution]

Hi,

Please see attached.

Hope it helps!

[vinieme12]

Try

=if(len(RevisedTargetDate)>0,RevisedTargetDate-Today(),OriginalTargetDate-Today())