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...
Get a quote
- We offer a price match guarantee.
- Set-up is simple, with a fully branded LMS, single sign-on and API integration.
- It works on desktop and mobile, so your team can train wherever suits them.
Once you’ve sent your details, one of our team will be in touch to talk you through your training options.