Return the latest date from a list of dates
 

with your list of dates in A1:A100
=MAX(A1:A100)

Cheers
JulieD

"davidp" wrote:

thanks. sometimes its right in front of you!
-----Original Message-----
with your list of dates in A1:A100
=MAX(A1:A100)

Cheers
JulieD

"davidp" wrote:



.

How would you adapt this if you wanted to find the latest date in a
particular month from a list of dates?

--
John
Delete extra @ to reply
"JulieD" wrote in message
...
with your list of dates in A1:A100
=MAX(A1:A100)

Cheers
JulieD

"davidp" wrote:

Assuming your dates are in column A, and the number of the month you wish to
call up is in C1........
put this in B1 and copy down.... =IF(MONTH(A1)=$C$1,A1,"")

then in D1 put this....... =MAX(B:B)

Vaya con Dios,
Chuck, CABGx3



"john.bedford3" wrote in message
...
How would you adapt this if you wanted to find the latest date in a
particular month from a list of dates?

--
John
Delete extra @ to reply
"JulieD" wrote in message
...
with your list of dates in A1:A100
=MAX(A1:A100)

Cheers
JulieD

"davidp" wrote:

On Thu, 17 Mar 2005 01:25:43 GMT, "john.bedford3"
wrote:

How would you adapt this if you wanted to find the latest date in a
particular month from a list of dates?

Assume:

Dates: named range including all your dates. Can be in any order.
Month: named range (cell) containing the month number (1=Jan)

Array formula:

=MAX((MONTH(Dates)=Month)*Dates)

To enter an array formula, you must hold down <ctrl<shift while hitting
<enter. XL will place braces {...} around the formula.


--ron

Thanks, I will keep a note of this for future reference. Ron's method suits
my spreadsheet better in this case.

John
"CLR" wrote in message
...
Assuming your dates are in column A, and the number of the month you wish
to
call up is in C1........
put this in B1 and copy down.... =IF(MONTH(A1)=$C$1,A1,"")

then in D1 put this....... =MAX(B:B)

Vaya con Dios,
Chuck, CABGx3



"john.bedford3" wrote in message
...
How would you adapt this if you wanted to find the latest date in a
particular month from a list of dates?

--
John
Delete extra @ to reply
"JulieD" wrote in message
...
with your list of dates in A1:A100
=MAX(A1:A100)

Cheers
JulieD

"davidp" wrote:

Thanks Ron that has solved another problem for me.

John
"Ron Rosenfeld" wrote in message
...
On Thu, 17 Mar 2005 01:25:43 GMT, "john.bedford3"

wrote:

How would you adapt this if you wanted to find the latest date in a
particular month from a list of dates?

Assume:

Dates: named range including all your dates. Can be in any order.
Month: named range (cell) containing the month number (1=Jan)

Array formula:

=MAX((MONTH(Dates)=Month)*Dates)

To enter an array formula, you must hold down <ctrl<shift while hitting
<enter. XL will place braces {...} around the formula.


--ron

On Thu, 17 Mar 2005 17:20:33 GMT, "john.bedford3"
wrote:

Thanks Ron that has solved another problem for me.

John

Glad to help. Thank you for the feedback.


--ron