» Counting Vacation or Sick Days within a Specified Time Period
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Listed in column A are dates when an employee was absent.
Column B contains a letter, indicating the type of each absence (V for vacation, S for sick).
We want to count the number of vacation days that occurred during the last 90 days.
Solution:
Use the SUM and TODAY functions in the Array formula:
{=SUM(((TODAY()-A2:A8)<=90)*(B2:B8=C2))}
To apply Array formula:
Select the cell, press
Book Store:
Recommended Books:
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Marketing Plans That Work, Targeting Growth and Profitability
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Absolute Beginner's Guide to Microsoft Office Excel 2003
Thanks
Rhonda Hewett
rhewett@fickewirth.com