FROMEXCELDATE
Excel stores dates as sequential serial numbers so that they can be used in calculations. The FROMEXCELDATE function converts an excel recognized serial number to the equivalent date in DD/MM/YYYY format. Node references are also accepted as arguments.
Syntax
Arguments
value- The numeric excel date value.
Return value
Date
Example
Returns 10/1/2008.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FFCqTvzcPnvvMXKFKg7L5%252Fimage.png%3Falt%3Dmedia%26token%3D2307295e-4f15-4149-9272-1236cd21fdf9&width=768&dpr=4&quality=100&sign=614e4c67&sv=1)
Last updated