Difference between revisions of "Manuals/calci/DATETOEXCEL"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''DATETOEXCEL(Date)'''</div><br/> *<math>Date</math> is any date. ==Description== *This function converts a date that is stored as text to a seri...") |
|||
| Line 7: | Line 7: | ||
*The date format is mentioned as [[http://wiki.zcubes.com/Manuals/calci/DATE DATE]] | *The date format is mentioned as [[http://wiki.zcubes.com/Manuals/calci/DATE DATE]] | ||
*If the year portion of the date_text argument is omitted, the DATEVALUE function uses the current year from your computer's built-in clock. Time information in the date_text argument is ignored. | *If the year portion of the date_text argument is omitted, the DATEVALUE function uses the current year from your computer's built-in clock. Time information in the date_text argument is ignored. | ||
| + | |||
| + | ==Examples== | ||
| + | #DATETOEXCEL("8/22")= 37125 | ||
| + | #DATETOEXCEL("10/22/1999") = 36455 | ||
| + | #DATETOEXCEL("9/17/2006") = 38977 | ||
| + | #DATETOEXCEL("9/5/2010") = 40426 | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/DATE | DATE]] | ||
| + | *[[Manuals/calci/DATEVALUE | DATEVALUE]] | ||
| + | *[[Manuals/calci/DAY | DAY]] | ||
| + | |||
| + | == References== | ||
| + | *[https://support.office.com/en-us/article/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252 Date Value] | ||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 02:18, 14 February 2020
DATETOEXCEL(Date)
- is any date.
is any date.Description
- This function converts a date that is stored as text to a serial number.
- This function is useful in where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations.
- The date format is mentioned as [DATE]
- If the year portion of the date_text argument is omitted, the DATEVALUE function uses the current year from your computer's built-in clock. Time information in the date_text argument is ignored.
Examples
- DATETOEXCEL("8/22")= 37125
- DATETOEXCEL("10/22/1999") = 36455
- DATETOEXCEL("9/17/2006") = 38977
- DATETOEXCEL("9/5/2010") = 40426