Calculating Number of Days for job length periods

Originally Posted by JBeaucaire

Try this in D1:

=IF(C1<>"",C1-A1,TODAY()-A1)

You are awesome, thanks for the quick response!!! It worked perfectly. Thanks

Joe