LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Formula to sum up the dates

I have column A with the date and column B with the name of person assigned
for the task. I would like to count how many tasks assigned to any particular
person for whole month based on column A dates.

A B
Jan 10, 2010 John C
Jan 12, 2010 Jason B
Jan 13, 2010 John C

John C was assigned two tasks in Month of Jan. Usally I have about 80 tasks
for 11 employees per month.

Thank you in advance for your help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dates formula Kristina1976 Excel Discussion (Misc queries) 3 April 27th 09 09:41 PM
Dates formula orquidea Excel Worksheet Functions 5 October 25th 07 02:09 AM
formula to add dates. S S Excel Worksheet Functions 8 April 5th 06 07:53 PM
formula for dates pascot Excel Discussion (Misc queries) 1 June 21st 05 08:33 AM
Dates in Formula John G Excel Discussion (Misc queries) 10 January 15th 05 03:48 PM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"