Working with dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top