getLastFridayOfMonth for Query

getLastFridayOfMonth.php

<?php
function getLastFridayOfMonth($year, $month) {
    // Start with the last day of the month
    $lastDay = new DateTime("$year-$month-01");
    $lastDay->modify('last day of this month');

    // Find the last Friday before or on the last day of the month
    if ($lastDay->format('N') < 5) {
        // If the last day is before Friday, subtract days to reach the last Friday
        $lastDay->modify('last Friday');
    } elseif ($lastDay->format('N') > 5) {
        // If the last day is after Friday, also move it to the last Friday
        $lastDay->modify('last Friday');
    }

    return $lastDay->format('Y-m-d');
}

// Example usage
echo getLastFridayOfMonth(2024, 10);