How can I count Dates in text format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this problem where the date fields are in text format, and I'm trying
to count the number of a person's work days.

Date Current Output Count Required Output Count
04/01/2005
04/01/2005
04/03/2005
04/04/2005
04/04/2005
5
3

Can I write a formula in the query to count on the day?

Any assistance will be appreciated.
 
You can create a query that groups by the Person and Date fields. Then
another based on the first that groups on the Person field and counts the
dates.
 
Back
Top