» Calculating the Date of the Nth Specific Day of the Month
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Special Edition Using Microsoft Word 2002
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- The Fall of Advertising and the Rise of PR
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- The Financial Numbers Game: Detecting Creative Accounting Practices
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
