![]() |
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