Number of days remaining based on 3 dates

[Brian2me]

Hello Exel Guru's,
I'm trying to calculate the either number of days remaining or the numbers of days between start and finish if an finish date has been entered.
A2 = Start Date = 01 Jan 21
B2 = Target Date = 01 Mar 21
C2 = Actual Date Completed = 01 Feb 21

D2 = if C2 = Blank then calculate B2-today() to calculate number of days left to complete task, but if C2 has a completed date then B2-A2 to understand number of days it took to complete task

 

[etaf]

=IF ( C2 = "" , B2 - today() , B2 - A2 )

Would that be C2 - A2 actual days to complete ? rather than B2 - A2 , which is target date - start date and would not change

=IF ( C2 = "" , B2 - today() , C2 - A2 )

 

[Brian2me]

Thanks you etaf, yes you were correct with the 2nd option. Disappointed that I didn't figure the formula out. I had used =if(C2="","", B2 - today() , B2 - A2)) but obviously failed due to first section

 

[etaf]

you are welcome