How to calculate difference between two dates in weeks in python

by

How about calculating the difference in weeks between the Mondays within weeks of respective dates? In the following code, monday1 is the Monday on or before d1 (the same week):

from datetime import datetime, timedelta

monday1 = (d1 - timedelta(days=d1.weekday()))
monday2 = (d2 - timedelta(days=d2.weekday()))

print 'Weeks:', (monday2 - monday1).days / 7

Returns 0 if both dates fall withing one week, 1 if on two consecutive weeks, etc.

More Related Contents:

  1. Converting string into datetime
  2. How do I parse an ISO 8601-formatted date?
  3. How to change the datetime format in Pandas
  4. Find if 24 hrs have passed between datetimes
  5. How to convert a UTC datetime to a local datetime using only standard library?
  6. Changing the formatting of a datetime axis in matplotlib
  7. Trying to mock datetime.date.today(), but not working
  8. subtract two times in python
  9. How can I account for period (AM/PM) using strftime?
  10. Parsing datetime strings containing nanoseconds
  11. Number of days between 2 dates, excluding weekends
  12. Get current time in milliseconds in Python?
  13. Generating random dates within a given range in pandas
  14. Inserting a Python datetime.datetime object into MySQL
  15. datetime from string in Python, best-guessing string format
  16. Converting string “Jun 1 2005 1:33PM” into datetime
  17. pandas to_datetime parsing wrong year
  18. Python speed testing – Time Difference – milliseconds
  19. Python/Pandas convert string to time only
  20. Convert Pandas Series to DateTime in a DataFrame
  21. Parameter unsupported when inserting int
  22. In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?
  23. Python – Convert string representation of date to ISO 8601
  24. time data does not match format
  25. pd.to_datetime is getting half my dates with flipped day / months
  26. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  27. Python summing up time
  28. Ceil a datetime to next quarter of an hour
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. Pandas: groupby forward fill with datetime index

Leave a Comment