FROMEXCELDATE
Was this helpful?
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.
fromexceldate(value)value- The numeric excel date value.
Date
fromexceldate(39457)Returns 10/1/2008.


Was this helpful?
Was this helpful?