Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Determining Date X based on Other dates | Excel Worksheet Functions | |||
Compare date against multiple dates | Excel Discussion (Misc queries) | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
count based on multiple date criteria | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |