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 DATE works kind of like the opposite of YEAR, MONTH and DAY: =DATE(year,month,day) If you tried this =DATE(2013,1,1), it would give you 01/01/2012 (or 41275, the Excel serial number that represents that date).