DATE Formula Excel How to use Excel DATE Function. Syntax of DATE Formula. Example of DATE Formula. Possible Errors returned by the DATE Formula. DATE formula in Excel returns the number representing the date for a given day, month and year. Use an update query in Access desktop databases to update or change the existing data in a set of records. This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Suppose you receive a spreadsheet with calculations, but the calculations are stored as. The DATE formula is typically used to construct a date by providing the constituting parts such as day, month and year. The minimum and maximum values that a date can take is Office 2. January 1, 1. 90. December 3. 1, 9. DATE Formula Syntax. DATE Formula has three parts DATE year, month, dayyearyear is the year in which the date would be occurring. The maximum value that the year can take in office 2. Provide Excel tutorials, tips and free VBA source code, including custom VBA Function, Sub Procedure. Update-Access-Database-From-Excel-2.jpg' alt='Update Access From Excel Table Function' title='Update Access From Excel Table Function' />Interesting to note is that the month is not limited to numbers lying between 1 and 1. For Example if you were to write a date function as DATE2. Jan 2. 00. 9. The result in this case would be January 1, 2. Again, just like the month parameter mentioned above, the day is not limited to numbers lying between 1 and 3. For Example if you were to write a date function as DATE2. Apr 2. 00. 9. The result in this case would be May 5, 2. Similarly you could use a negative number generate a date in the past. Loading DocCommentXchange. Loading DocCommentXchange. Hello there, I have an excel spreadsheet that is importing data from an access database. The date fields are formatted like 40003, and I have formatted that. Susan Harkins shows you how to combine familiar features to create more flexible Excel Table objects. You can even enter fractions though that would not be much use. Example of a DATE Formula. Lets us take a look at an example of the DATE formula. Suppose we had the year, month and day provided to us as three separate fields. We wanted to combine all three to generate a date. As shown above, we could write something like DATEA2,B2,C2. The result in this case is January 1. Formatting a DATE in Excel. Anytime you have present information that contains dates, please ensure that you have them formatted so that the user can at the first glance make them out clearly. There are a number of date formats in use and with each department, company and country following their own nomenclature. I personally tend to like the dd mmm yyyy or the mmm dd yyyy formats so that there is no room left for ambiguity. Download English Grammar Explanations Articles About Education. To format a date, while the cursor is on the cell you want to format, press Ctrl 1. That would open up the format cell option box. Choose the Number tab and click on Date. In the Type, select the format you like. How to enter the DATE formula in an Excel Sheet. Select the cell in which you want to place the formula. Type the formula as DATE3. Then enter the year in which the date we are trying to create occurs. Press the comma key ,5. Then enter the month in which the date we are trying to create occurs. Remember that you can use any number negative or positive as mentioned in the first section above. Press the comma key ,7. Then enter the month in which the date we are trying to create occurs. Close the formula by entering the closing bracket. Check out the clip above for knowing if the values youve entered are in the same order. In the end your formula should look something like this DATE2. Possible Errors with the DATE Formula. The DATE formula can result in the following error values DATE Formula NUM Error. If the parameters specified in the year, month or day cause the resulting date to exceed the minimum and maximum limits January 0, 1. December 3. 1, 9. Excel 2. 00. 3, the DATE function would result in the NUM Ex. If you wanted to enter 2. DATE2. 00. 09,4,7, that would result in this error. DATE Formula NAME Error. If the parameters have been specified incorrectly entering string instead of a number, the DATE function can result in the NAME For example, say you entered jul as the month instead of 7 which is the number representing the month July and entered DATE2. NAME error. You can download an example of DATE formula here or click on the button below. Google Maps distance function for Excel. Function. GDISTANCEOrigin As. String,Destination As. StringAs. Double Requires a reference to Microsoft XML, v. Draws on the stackoverflow answer at bit. XMLDimmy. Request As. XMLHTTP6. 0Dimmy. Dom. Doc As. DOMDocument. Dimdistance. Node As. IXMLDOMNode    GDISTANCE0     Check and clean inputs    On Error. Go. Toexit. Route    OriginWorksheet. Function. Encode. URLOrigin    DestinationWorksheet. Function. Encode. URLDestination     Read the XML data from the Google Maps API    Setmy. RequestNew. XMLHTTP6. Request. OpenGET,http maps. Origin destination Destination sensorfalse,False    my. Request. send     Make the XML readable usign XPath    Setmy. Dom. DocNew. DOMDocument. Dom. Doc. Load. XML my. Request. response. Text     Get the distance node value    Setdistance. Nodemy. Dom. Doc. Select. Single. Nodelegdistancevalue    If. Notdistance. Node Is. Nothing. Then. GDISTANCEdistance. Node. Text1. 00. Route     Tidy up    Setdistance. NodeNothing    Setmy. Dom. DocNothing    Setmy. RequestNothing. End.