Explanation
The DATE function builds dates from separate year, month, and day values.
The formula on this page takes advantage of this behavior.
The day value comes from column B, and the DATE function calculates the date as explained above.
Themonthis supplied as 1, as in the first example.
For example, =RIGHT(“apple”,3) returns “ple”.
For example, =LEFT(“apple”,3) returns “app”.
