Think you could get by with:
=IF(K4="",0,A2-K4)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Harley" wrote:
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.