Bolt pattern or bolt circle is the diameter of an imaginary circle formed by the centers of the wheel lugs. Bolt patterns can be 4-, 5-, 6-, or 8-lug holes. A bolt circle of 4x100 would indicate a 4-lug pattern on a circle with a diameter of 100mm.
1. Select a cell that you want to insert current year, month or day, and click the Kutools > Insert > Insert Date, see screenshot: 2. In the Insert Date dialog, check the Using format option, and then double click a date formatting in the right pane. See screenshot above:
The YEAR() function returns the Year portion of a date within Excel. Now that we have two dates we can use the YEAR() function to calculate the difference in years between the two dates. The formula will look like this: You can either type the function into the cell directly or use the Formula tab to add the formula.