D
DDR1974
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,
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,