Calculate Difference Between Two Dates - empty cells show today

[buer4499]

Hello,

I am struggling to find a formular which shows the following:

First Name	Last Name	Start Date	Leave Date	Tenure (Days)
FIRST 1	LAST 1	07/05/2016​
FIRST 2	LAST 2	10/10/2016​	01/05/2021​	1664
FIRST 3	LAST 3	23/08/2017​	23/08/2018​	365
FIRST 4	LAST 4	13/11/2017​
FIRST 5	LAST 5	11/01/2018​

If D-C = Tenure in Days. If no leave date, show tenure up to today's date.

So D-C=Tenure if no D show C to today.

If that makes sense?

Thanks,

 

[Fluff]

How about

=IF(D2="",TODAY(),D2)-C2

 

[jasonb75]

As long as the leave date cells are empty,

=MIN(TODAY(),D2)-C2