Excel - DATE function
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.
=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.
Comments
Post a Comment