Counting how many records within date range(s)
Posted by Sheila Vaughan on September 12, 2001 1:37 AM
I have copied an employee table from Access to Excel. One field is 'Date of Appointment'. I now want to count how many people have been appointed since a particular date or within a particular period. I don't want to use the Excel 'serial numbers' as HR managers wouldn't be able to cope with that. With previous versions of Excel I used the COUNTIF function without any problem but it doesn't seem to work now with "standard" dates. Can anyone help?