LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian
 
Posts: n/a
Default Compare multiple dates, can enumerate cell based on most recent date

Howdy All,

This is what I want to do:

I have a spreadsheet with 4 dates in columns I, J, K, and L starting in row
3.

In the corresponding columns of row 1, i want to count the number of times
each column contains the most recent date.

Example:

I3 = 1/1/2000, J3 = 2/2/2001, K3 = 3/3/2002, L3 = 4/4/2003

L3 would now equal 1.

Then next time column L contains the most recent date, L3 would enumerate
and equal 2, etc.

Any ideas?

Thanks,
Brian


 
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
Determining Date X based on Other dates MIchel Khennafi Excel Worksheet Functions 1 May 3rd 06 04:45 PM
Compare date against multiple dates Struggling Excel Discussion (Misc queries) 1 April 26th 06 03:19 PM
Dates of a Day for a month & year cell formulas mikeburg Excel Discussion (Misc queries) 2 December 29th 05 10:14 PM
count based on multiple date criteria lisaw Excel Worksheet Functions 1 August 9th 05 05:31 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 04:41 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"