The City of Bullard, Texas, with a population of 2,463, is located on U. S. Hwy. 69 South in Smith and Cherokee Counties approximately 8 miles south of Tyler.
Dates. Excel provides two options for calculating the difference between two dates. You can use a simple subtraction operation such as =B2-A2 to calculate the amount of days between those two calendar dates.perators. Find the difference between two values using the subtraction operation. To subtract values of one field from another, both fields must contain the same data type. For example, if you have 8 in one column and subtract it from four in another column, Excel will not be able to perform the calculation.
If you type a number that resembles a date, for example a fraction 12/7 then Excel will probably think it is a date and make it 7-Dec. If you just format the cell afterwards, then you will get a number that is the date as a serial number. Not what you want and you will have to enter your number again. So, format your cells first for numbers if you are going to be entering any number that could resemble a date. Excel really likes to make things dates.