How to convert a python datetime.datetime to excel serial date number

by

It appears that the Excel “serial date” format is actually the number of days since 1900-01-00, with a fractional component that’s a fraction of a day, based on http://www.cpearson.com/excel/datetime.htm. (I guess that date should actually be considered 1899-12-31, since there’s no such thing as a 0th day of a month)

So, it seems like it should be:

def excel_date(date1):
    temp = dt.datetime(1899, 12, 30)    # Note, not 31st Dec but 30th!
    delta = date1 - temp
    return float(delta.days) + (float(delta.seconds) / 86400)

More Related Contents:

  1. Convert Excel style date with pandas
  2. How do I read a date in Excel format in Python?
  3. Convert date from excel in number format to date format python [duplicate]
  4. Leave dates as strings using read_excel function from pandas in python
  5. How to print a date in a regular format?
  6. Convert UTC datetime string to local datetime
  7. How to make a timezone aware datetime object in Python?
  8. Pandas Dataframe line plot display date on xaxis
  9. Adding days to a date in Python
  10. How to convert integer timestamp into a datetime
  11. How do you convert a time.struct_time object into a datetime object?
  12. How to round the minute of a datetime object
  13. In Python, how do you convert seconds since epoch to a `datetime` object?
  14. Inserting a Python datetime.datetime object into MySQL
  15. Converting string “Jun 1 2005 1:33PM” into datetime
  16. pandas to_datetime parsing wrong year
  17. Python/Pandas convert string to time only
  18. Convert Pandas Series to DateTime in a DataFrame
  19. Convert dataframe index to datetime
  20. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  21. Adjust cell width in Excel
  22. Get Excel-Style Column Names from Column Number
  23. How to get current date and time from GPS unsegment time in python
  24. How to convert a Date string to a DateTime object?
  25. Seaborn tsplot does not show datetimes on x axis well
  26. Group DataFrame in 5-minute intervals
  27. Convert a column of timestamps into periods in pandas
  28. Automation Excel from Python
  29. how to specify the datetime format in read_csv
  30. Python generating a list of dates between two dates

Leave a Comment