Get week number in month from date in PHP?

by

I think this relationship should be true and come in handy:

Week of the month = Week of the year - Week of the year of first day of month + 1

We also need to make sure that “overlapping” weeks from the previous year are handeled correctly – if January 1st is in week 52 or 53, it should be counted as week 0. In a similar fashion, if a day in December is in the first week of the next year, it should be counted as 53. (Previous versions of this answer failed to do this properly.)

<?php

function weekOfMonth($date) {
    //Get the first day of the month.
    $firstOfMonth = strtotime(date("Y-m-01", $date));
    //Apply above formula.
    return weekOfYear($date) - weekOfYear($firstOfMonth) + 1;
}

function weekOfYear($date) {
    $weekOfYear = intval(date("W", $date));
    if (date('n', $date) == "1" && $weekOfYear > 51) {
        // It's the last week of the previos year.
        return 0;
    }
    else if (date('n', $date) == "12" && $weekOfYear == 1) {
        // It's the first week of the next year.
        return 53;
    }
    else {
        // It's a "normal" week.
        return $weekOfYear;
    }
}

// A few test cases.
echo weekOfMonth(strtotime("2020-04-12")) . " "; // 2
echo weekOfMonth(strtotime("2020-12-31")) . " "; // 5
echo weekOfMonth(strtotime("2020-01-02")) . " "; // 1
echo weekOfMonth(strtotime("2021-01-28")) . " "; // 5
echo weekOfMonth(strtotime("2018-12-31")) . " "; // 6

To get weeks that starts with sunday, simply replace date("W", ...) with strftime("%U", ...).

More Related Contents:

  1. How to sort date array in php?
  2. PHP order array by date? [duplicate]
  3. Get date range between two dates excluding weekends
  4. Get most recent date from an array of dates in “Y-m-d H:i:s” format
  5. PHP 01/01/1970 Issues with Date Fields
  6. PHP multidimensional array search by value
  7. How to sum all column values in multi-dimensional array?
  8. How to convert JSON string to array
  9. Modify array values in foreach loop
  10. How to check if PHP array is associative or sequential?
  11. mysqli bind_param() expected to be a reference, value given
  12. Build a tree from a flat array in PHP
  13. Convert a comma-delimited string into array of integers?
  14. Convert array into csv
  15. The first day of the current month in php using date_modify as DateTime object
  16. Get difference between associative rows of two 2-dimensional arrays
  17. Sort an array by a child array’s value in PHP
  18. Convert flat array to the multi-dimensional
  19. get next and previous day with PHP
  20. How to pass an array via $_GET in php?
  21. Getting last month’s date in php
  22. Get the maximum value from an element in a multidimensional array? [duplicate]
  23. Move an array element to a new index in PHP
  24. PHP get all arguments as array?
  25. Format date from database?
  26. Convert PHP array string into an array
  27. Push item to associative array in PHP
  28. PHP Spread Syntax in Array Declaration
  29. How do I convert an ISO8601 date to another format in PHP?
  30. Implementing a simple lookup array

Leave a Comment