» Calculating the Date of the Nth Specific Day of the Month
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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))))
Book Store:
Recommended Books:
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Special Edition Using Microsoft Office XP
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
No comments have been submitted.
