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:
In your Excel YEAR formulas, you can specify dates in several ways: 1  Using the DATE For example, the following formula returns the year for 28 April, 2015: =YEAR(DATE(2015,4,28)) 2  As a serial number representing the date (for more information on how dates are stored in Excel, please see Excel date format).