In any case, blood in the dog's stool should not be taken lightly and you should always take him or her to the vet as soon as possible. In the meantime, you can feed them white rice with a little garlic or garlic powder mixed in, boiled potatoes, green beans, or a little boiled chicken. When there is blood in a dog's stool. Yeah, it can be quite a scare, but when there is blood in a dog's stool and it doesn't always mean a trip to the emergency clinic.
If that's a valid date/time entry then excel simply stores it as a number (days are integers and the time is the decimal part) so you can do a simple subtraction. I'm not sure if 7/6 is 7th June or 6th July, assuming the latter then it's a future date so you can get the difference in days with. =INT(A1-TODAY()).
Different Ways to Subtract Dates. There are several types of computations that involve dates and subtraction in Excel. For instance, you may want to find the difference in days, months, or years between two dates in order to determine the amount of time that passed from the beginning to the end of an event.f youâre only interested in determining the number of days between two dates, the calculation is very simple. All you have to do is subtract the two cells. That is, if the first date is in cell A2 and the second one in cell B2, you can use the basic formula. = B2 â A2. as shown in the screenshot below.