Date & Time functions
FIRST.MONDAY
About
Returns the first Monday of the month.
Code
  M.S. Excel
  
FIRST.MONDAY = LAMBDA(anydate,
    LET(
        start_of_month, DATE(YEAR(anydate), MONTH(anydate), 1),
        CHOOSE(WEEKDAY(start_of_month), 1, 0, 6, 5, 4, 3, 2) + start_of_month
    )
);
                        
                            
                        
                    Feedback
Submit and view feedback