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.

Try this:

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

--
Biff
Microsoft Excel MVP


"Harley" wrote in message
...
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.

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.

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


"Max" wrote in message
...
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.