Day count if cell is blank

[gleppelman]

Hello and Thanks in advance for any help.

Probably ez mode for most of you.

Column J Column K Column L
Due Date Completion Date Days until due, unless column k has a date in it, then blank
[code}
=j1-today() [I]Please Login or Register to view this content.[/code]

The Alignments confusing. J is Due date, K is Completion date, and L is days until due, or blank based on a date being present in K.

Thanks again

[L-Drr]

In L1: =IF(K1="",J1-TODAY(),"") and format as Numer

I've assumed that if K does not have a date in it, there's also nothing else in it

[gleppelman]

Perfect Thank you very much.

[L-Drr]

You're welcome!
Please consider adding to my reputation (lower left corner of my post)