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.
=B2-B1. =month(b2)-month(b1). =year(b2)-year(b1). Placing date and time stamps into Excel is easy enough but sometimes you need to know the number of days, months, or years between two different dates.alculating the number month between two dates in Excel is useful when you are figuring out loan, mortgage, or other annuity payments. However, subtracting dates to get months in Excel is a bit trickier and rarely returns the result you expected.