PDA

View Full Version : Excel count function of dates within a range



13-04-1999, 10:18 PM
I currently track work how long jobs take to compelte using the net working days formula in Excel. I am looking for an easy way to count the number of jobs completed each month (eg how many jobs were completed between 1 March - 31 March)- I assume based on a count of one of the date rows. I have tried different combinations of countif/and/or forumulas - all without success. Yet I assume this should be easy? I understand how excel recognises dates as numbers - I've tried a =<>= formula. I suspect I am close - but am now completely stuck ! Would really appreciate some help