Link to home
Start Free TrialLog in
Avatar of LUIS FREUND
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
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LUIS FREUND
LUIS FREUND

ASKER

Thanks for everyone's effort!