LUIS FREUND
asked on
Counting Dates in Excel
Wanted to see if there is an easier way to count dates from two columns. I have several hundred rows of data that I would want to count dates from.
On column B (Create_Date) and column D (Complete_Date) i wanted to count how many times for example 6/1/18 showed up and for future dates coming up. I did the manual count on columns G and H to illustrate what I was looking for but wanted to see if this can be done automatically.
See Attachment
C--Users-lfreund-Desktop-Excel-COUN.xlsx
On column B (Create_Date) and column D (Complete_Date) i wanted to count how many times for example 6/1/18 showed up and for future dates coming up. I did the manual count on columns G and H to illustrate what I was looking for but wanted to see if this can be done automatically.
See Attachment
C--Users-lfreund-Desktop-Excel-COUN.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER