The user has a vacation calendar that ranges from Jan-1-17 thru basically 2079 in a workbook.
The user is looking to calculate the amount of vacation days taken per person during a particular year.
If 2018 is selected from a drop down, basically it will count the number of instances "V" is identified between two dates (Jan1-18~Dec31-18), for that particular individual.
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
|How to count the frequency of a specific number on a specific day|
|How to count non blanks 5 years from the last non blank date|
|How to count worksheets|
|How to count times between 2 specified times|