» Counting Vacation or Sick Days within a Specified Time Period
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.
Use the SUM and TODAY functions in the Array formula:
To apply Array formula:
Select the cell, press and simultaneously press .