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:
So, we write a formula that will see if our year is in between the Start and End dates. Excel will return the year of a given date if we use the =YEAR() function, this makes the math easy! Notice it references cell D1 absolutely, the $ signs mean it will not change as you drag it down the column.