CFLib.org – Common Function Library Project

Description:
Return the 'Date' format that Excel demands which is, in fact, a numeric representation of a date created by the difference in the number of days, between the date in question and Dec. 31, 1899

Return Values:
Returns a number.

Example:

<cfoutput>#date2ExcelDate(now())#</cfoutput>

Parameters:

Full UDF Source:

function date2ExcelDate(dateString) {
    var rtrnString = '';
    if(isDate(dateString)) {
        return dateDiff("d", createDate( 1899,12,30 ), dateString);
    };
                
    return rtrnString;
};