Login

Excel Date

Author:
cronosa
Posted:
April 14, 2010
Language:
Python
Version:
1.1
Score:
0 (after 0 ratings)

This allows you to just call excel_date and it will convert any dates between excel and python datetime.

1
2
3
4
def excel_date(value):
	value = float(value) - 2
	edate = datetime.datetime(year=1900,month=1,day=1)
	return edate + datetime.timedelta(days=value)

More like this

  1. get_object_or_none by azwdevops 3 months, 2 weeks ago
  2. Mask sensitive data from logger by agusmakmun 5 months, 1 week ago
  3. Template tag - list punctuation for a list of items by shapiromatron 1 year, 7 months ago
  4. JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 1 year, 7 months ago
  5. Serializer factory with Django Rest Framework by julio 2 years, 2 months ago

Comments

pakalk (on April 15, 2010):

You could explain input and output values. Example?

#

Please login first before commenting.