» 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:
- Microsoft Windows XP Step by Step (With CD-ROM)
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Fish! A Remarkable Way to Boost Morale and Improve Results
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Finance and Accounting for Nonfinancial Managers
- Marketing Management
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
