Module 25 : DATE Formula
25.1 DATE Formula The DATE function is useful when you need to take three values presented separately and combine them to form a date. The formula for the DATE function is: =DATE(year,month,day) Remember that all three need to be presented as numbers for it to return a date. For example, if you input =DATE(2015,4,6), Excel will return April 6th, 2015. Note that Excel doesn't accept years earlier than 1900. A couple of extra exercises you can try (not in the video) are: To insert the curr...
Request a quote
- We offer a price match guarantee.
- No hassle set-up. Fully branded LMS with single sign-on and API integration.
- Desktop and mobile compatible. Train anywhere, anytime.
Once submitted, a member of our team will be in touch to talk you through your training options.