Working with dates

[Guest]

Trying to subtract dates to determine # of days in inventory. But only want
the calculation to be performed if there is an ending date entered i.e. A2-K4
(A2 equals todays date and K4 equals the ending date) will give me my days in
inventory, but I only want the value if an ending date has been entered into
K4. If no date has been entered, the number of days should remain 0.
Currently, when I extend my formula, it gives me a very high default number
when no ending date has been entered.

 

[T. Valko]

Try this:

=IF(K4=0,0,A2-K4)

 

[Guest]

Think you could get by with:
=IF(K4="",0,A2-K4)

 

[Rick Rothstein \(MVP - VB\)]

Assuming, like you did, that K4 will have nothing in it (as opposed to 0)
when "no date has been entered"; then this will work also...

=A2-MIN(A2,K4)

Rick