Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting latest date in two columns
I have a spreadsheet with 2 columns of dates (approximately 1200 rows) and
want the count in column A where the date is less than column B. A B 1/2/09 1/8/09 4/5/08 5/6/07 5/6/09 9/5/08 In the above example the answer I'm looking for is 1. -- Robert K |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter latest date from multiple date entries | Excel Worksheet Functions | |||
X axis date - display beyond latest date. | Charts and Charting in Excel | |||
Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
Finding the Latest Date from Several Dates in Different Columns | Excel Discussion (Misc queries) | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions |