In this video, I demonstrate how to use the DATE function in Excel. I take you through two examples: how to combine three cells into a single date and how to calculate 65 years from a certain date using the DATE function.

Syntax: DATE(year,month,day)
Assume that cell A2 has the month, B2 has the day, and C2 has the year. A2 contains August as the number 8, B2 contains the ninth as the number 9, and C2 contains 2024. In D2, = DATE (C2, A2, B2) would return 8/9/2024. Notice the function goes year, month, and day.

Another reason for using the DATE function is to add years, months, or days to a date. For example, if cell E2 has the date 11/4/2024, and you want to add 3 years to the date, your formula would be =DATE(Year(E2)+3,MONTH(E2),DAY(E2)). Screenshot below
https://drive.google.com/file/d/16U5O...

Online Training courses in Teams, Excel, and Copilot
https://courses.chrismenardtraining.com

Thanks for watching, and make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!