Use Excel's DATE function when you need to take three separate values and combine them to form a date. Technical details. Change the date format. Calculate a date based on another date. Convert text strings and numbers into dates. Increase or decrease a date by a certain number of days. See Also. Add or subtract dates. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.