LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 101
Default Macro to Check Dates

I have a list of names and dates whereby the names could be listed multiple
times. What I would like to define is how many days there are between the
dates that a name appears. As an example the name Frank appears with a date
of 01/01/2010 and then appears down the list again with a date of 03/01/2010.
How many days are there between each date for Frank. Frank could be listed
more than twice, multiple times. Also there are probably 20 different names
in this list that are listed multiple times with different dates and the list
is at least a year old.
 
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
Check dates against a date range. hombreazul Excel Discussion (Misc queries) 0 January 30th 12 12:57 AM
Error Check Dates jlclyde Excel Discussion (Misc queries) 1 December 22nd 08 09:13 PM
Help! I need a macro to check dates and autopopulate cells Monomeeth Excel Programming 3 May 6th 08 11:49 PM
check for certain dates in excel Pivot Table/Query Excel Programming 2 November 1st 05 09:36 PM
Check Dates John Excel Programming 2 September 13th 04 06:36 PM


All times are GMT +1. The time now is 01:40 AM.

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"