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:
Steps. 1  1. Turn on your computer and open a new or existing Excel spreadsheet. 2  2. In any cell, for this example we will use A2, type in you date. Ex. 1/1/2006. 3  3. In a different cell, for this example we used B2, type in the amount of months cell A2 is to be incremented by. Ex. 4  5. 4. In the last cell type the formula: =DATE(YEAR(A2),MONTH(A2)+B2,MIN(DAY(A2),DAY(DATE(YEAR(A2),MONTH(A2)+B2+1,0)))) replacing what is in bold with the appropriate cells for your spreadsheet. 5. You will see that this cell now has the calculation desired.