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()).
Similarly, the formula to calculate the number of complete years is =DATEDIF(A1,A2,y) , although in our example it would yield 0 complete years. Change cell A1 to a date a year or more earlier and you'll see the result. A couple of things to keep in mind about the DATEDIF function:owever, calculating the number of months or years between two dates isn't so obvious. There's a Function in Excel that makes this task easy but for some reason Microsoft has hidden it away. You won't find it in the Paste Functions list (Insert, Functions).