» Determining whether Two Given Dates Occur within the Same Week
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem: Determining whether each pair of corresponding dates in columns A & B occur within the same week.
Solution:
Use the WEEKNUM and IF functions as shown in the following formula:
=IF(WEEKNUM(A2,2)=WEEKNUM(B2,2),"Same Week","Different Week")
Book Store:
Recommended Books:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Now, Discover Your Strengths
- Microsoft Excel 2002 Simply Visual
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
No comments have been submitted.
