|  

» Calculating the Date of the Nth Specific Day of the Month

Problem:

Calculating the date of, for example, the first Saturday of each of the months listed in column A, for the year specified in cell B2.

Solution:

Use the WEEKDAY and DATE functions as shown in the following formula:
=DATE($B$2,A2,1+((1-(6>=WEEKDAY(DATE($B$2,A2,1),2)))*7+(6-WEEKDAY(DATE($B$2,A2,1),2))))

Rate This Tip
12 34 5
Rating: 3.31     Views: 20981
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments