Converting Excel Date Serial Number to Date using Javascript

by

Try this:

function ExcelDateToJSDate(serial) {
   var utc_days  = Math.floor(serial - 25569);
   var utc_value = utc_days * 86400;                                        
   var date_info = new Date(utc_value * 1000);

   var fractional_day = serial - Math.floor(serial) + 0.0000001;

   var total_seconds = Math.floor(86400 * fractional_day);

   var seconds = total_seconds % 60;

   total_seconds -= seconds;

   var hours = Math.floor(total_seconds / (60 * 60));
   var minutes = Math.floor(total_seconds / 60) % 60;

   return new Date(date_info.getFullYear(), date_info.getMonth(), date_info.getDate(), hours, minutes, seconds);
}

Custom made for you 🙂

More Related Contents:

  1. How to calculate number of days between two dates?
  2. Get week of year in JavaScript like in PHP
  3. How do you display JavaScript datetime in 12 hour AM/PM format?
  4. Javascript add leading zeroes to date
  5. JavaScript seconds to time string with format hh:mm:ss
  6. Get the time difference between two datetimes
  7. Comparing date part only without comparing time in JavaScript
  8. Get String in YYYYMMDD format from JS date object?
  9. new Date() works differently in Chrome and Firefox
  10. how to parse a “dd/mm/yyyy” or “dd-mm-yyyy” or “dd-mmm-yyyy” formatted date string using JavaScript or jQuery [duplicate]
  11. Parsing a string to a date in JavaScript
  12. new Date() is working in Chrome but not Firefox
  13. ToLocaleDateString() changes in IE11
  14. How to format a UTC date as a `YYYY-MM-DD hh:mm:ss` string using NodeJS?
  15. Check if one date is between two dates
  16. How to JSON stringify a javascript Date and preserve timezone
  17. Min/Max of dates in an array?
  18. Checking if two Dates have the same date info
  19. How to get year/month/day from a date object?
  20. how to determine if date is weekend in javascript [closed]
  21. Calculate Timezone offset only for one particular timezone
  22. How to split a string at the first `/` (slash) and surround part of it in a “?
  23. Format date and Subtract days using Moment.js
  24. Javascript Invalid Date Error in Internet Explorer
  25. Copy/Paste from Excel to a web page
  26. Getting the date of next Monday
  27. Java date format to JavaScript date format
  28. Generate random date between two dates and times in Javascript
  29. Convert iso timestamp to date format with Javascript?
  30. How to convert Moment.js date to users local timezone?

Leave a Comment