ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   counting dates within a timeframe (https://www.excelbanter.com/setting-up-configuration-excel/148237-counting-dates-within-timeframe.html)

DDR1974

counting dates within a timeframe
 
On a "Monthly View" worksheet I have several date columns which represent
milestones in a timeline.
I also have a MONTH-YEAR cell in which the coordinator enters a month-year,
and using a VBA button, retrieves the full row of data from project-specific
spreadsheets in the same workbook which contain at least 1 date that falls
within that MONTH-YEAR.
I would like to count in each column the number of dates that fall within
the specified MONTH-YEAR. It seems I should be able to use COUNTIF but I
haven't been able to get it to work.
I did successfully use conditional formatting to make the dates that occur
in the specified MONTH-YEAR a different-colored font, but a count would be
helpful (for graphs - # projects within a specific function, etc.).
Thank you, best regards,



All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com