How do I convert an Excel serial date number to a .NET DateTime?

by

I find it simpler using FromOADate method, for example:

DateTime dt = DateTime.FromOADate(39938);

Using this code dt is “05/05/2009”.

More Related Contents:

  1. Clean up Excel Interop Objects with IDisposable
  2. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  3. Calculate week of month in .NET
  4. The proper way to dispose Excel com object using VB.NET?
  5. How to count the number of rows in excel with data?
  6. Why can’t DateTime.ParseExact() parse “9/1/2009” using “M/d/yyyy”
  7. VB.Net – Excel COM Object not getting released [duplicate]
  8. SqlDateTime.MinValue != DateTime.MinValue, why?
  9. What is the correct format to use for Date/Time in an XML file
  10. How to get COM Server for Excel written in VB.NET installed and registered in Automation Servers list?
  11. JavaScriptSerializer UTC DateTime issues
  12. .NET DateTime.Now returns incorrect time when time zone is changed
  13. OpenXML SDK: Make Excel recalculate formula
  14. Windows 7 .net Excel .SaveAs() Error Exception from HRESULT: 0x800A03EC
  15. Can you round a .NET TimeSpan object?
  16. How to write an Excel workbook to a MemoryStream in .NET?
  17. Translate a column index into an Excel Column Name
  18. How do I parse and convert DateTime’s to the RFC 822 date-time format?
  19. Does .NET have the history of time zone changes?
  20. How to convert date format in vb.net?
  21. When Would You Prefer DateTime Over DateTimeOffset
  22. VB.NET Excel Program Leaves EXCEL.EXE floating after completion
  23. .net: How to parse a date with this format: 08 Feb 2011 06:46
  24. How to control appearance of ‘:’ in time zone offset when parsing/formatting Datetime
  25. My images are blurry! Why isn’t WPF’s SnapsToDevicePixels working?
  26. C# compiling for 32/64 bit, or for ‘Any CPU’? [duplicate]
  27. How to retrieve duration of MP3 in .NET?
  28. Detecting the number of processors
  29. How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
  30. Is it safe to call an RCW from a finalizer?

Leave a Comment