» Determining whether Two Given Dates Occur within the Same Week
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- Financial Risk Manager Handbook, Second Edition
- Microsoft Excel Version 2002 Step by Step
- Windows XP All-in-One Desk Reference For Dummies
- Accounting for Dummies
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
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
