help with formula
 

Hi,

I need a formula that will serch an array of dates and generate the latest
date in the cell.

Any ideas?

help with formula
 

With dates in column A, try this to find the latest:

=MAX(A:A)

Format the cell as a date. You can use a specific range if you like:

=MAX(A1:A100)

Hope this helps.

Pete

On May 9, 3:09*pm, carol wrote:
Hi,

I need a formula that will serch an array of dates and generate the latest
date in the cell.

Any ideas?

help with formula
 

=max(a2:a100)

format as date

Assuming that your data is on a2:a100 range.


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"carol" escreveu:

Hi,

I need a formula that will serch an array of dates and generate the latest
date in the cell.

Any ideas?

help with formula
 

Great thanks, that worked!

"Marcelo" wrote:

=max(a2:a100)

format as date

Assuming that your data is on a2:a100 range.


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"carol" escreveu:

Hi,

I need a formula that will serch an array of dates and generate the latest
date in the cell.

Any ideas?

help with formula
 

Great thanks, that worked!

"Pete_UK" wrote:

With dates in column A, try this to find the latest:

=MAX(A:A)

Format the cell as a date. You can use a specific range if you like:

=MAX(A1:A100)

Hope this helps.

Pete

On May 9, 3:09 pm, carol wrote:
Hi,

I need a formula that will serch an array of dates and generate the latest
date in the cell.

Any ideas?

help with formula
 

thanks for the feedback
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"carol" escreveu:

Great thanks, that worked!

"Marcelo" wrote:

=max(a2:a100)

format as date

Assuming that your data is on a2:a100 range.


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"carol" escreveu:

Hi,

I need a formula that will serch an array of dates and generate the latest
date in the cell.

Any ideas?

help with formula
 

You're welcome, Carol - thanks for feeding back.

Pete

On May 9, 3:34*pm, carol wrote:
Great thanks, that worked!