Blog of Calc LLC

DATE function generates a date given year, month, and day. For example, DATE(2020, 5, 18) returns 5/18/2020 . Syntax DATE(year, month, day) Example Notes If a month or day is too big or small to be legitimate date, it will be converted silently. For example, if the month part is 13, it will be automatically converted into 1 by adding 1 to the year part. Similar is for the day part. Decimals will be truncated so 12.75 is same as 12. Year should be between 0 and 9999.

DATE function generate a date from year, month and day. For example: =DATE (A2, B2, C2) Note: 1. If the date is shown as numbers, like below, you need to format it as date. 2. Always use four digit years such as 1978 or 2020. If you use two-digit years such as 20, it may not be what you want.