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.
=DAYS(B2,A2). This formula will work with normal dates as well as dates formatted as text. If either the start date or end date is a text value, Excel will try to convert it to date (you would use the DATEVALUE function for this).DAYS(B2,A2). This formula will work with normal dates as well as dates formatted as text. If either the start date or end date is a text value, Excel will try to convert it to date (you would use the DATEVALUE function for this).