Forum Home
Press F1
 
Thread ID: 1255 1999-04-13 10:18:00 Excel count function of dates within a range Guest (0) Press F1
Post ID Timestamp Content User
1607 1999-04-13 10:18:00 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 Guest (0)
1