| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for the earliest/latest date in a column
I have a spreadsheet that has 2 columns of dates. In the first column, I
want to find the earliest date and in the second column, I want to find the latest date. Is there a function within excel that will find that information for me? -- DMM |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for the earliest/latest date in a column
Earliest
=MIN(A:A) Latest =MAX(B:B) HTH "soconfused" wrote: I have a spreadsheet that has 2 columns of dates. In the first column, I want to find the earliest date and in the second column, I want to find the latest date. Is there a function within excel that will find that information for me? -- DMM |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for the earliest/latest date in a column
Here are the funtions you should use:
First Column (I will use column A in my example) =min(A:A) Second Column (I will use column B in my example) =max(B:B) "soconfused" wrote: I have a spreadsheet that has 2 columns of dates. In the first column, I want to find the earliest date and in the second column, I want to find the latest date. Is there a function within excel that will find that information for me? -- DMM |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for the earliest/latest date in a column
Thank you so much. I've been struggling for a couple of hours with this.
-- DMM "Toppers" wrote: Earliest =MIN(A:A) Latest =MAX(B:B) HTH "soconfused" wrote: I have a spreadsheet that has 2 columns of dates. In the first column, I want to find the earliest date and in the second column, I want to find the latest date. Is there a function within excel that will find that information for me? -- DMM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating earliest start and latest end dates by contract | Excel Worksheet Functions | |||
| Earliest and latest dates that can be correctly represented in Exc | Excel Discussion (Misc queries) | |||
| Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
| Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
| Display latest date in a column | Excel Worksheet Functions | |||
Linear Mode
